/Shell/Bash/Postgresql user permissions to database

Postgresql user permissions to database

sudo -u postgres 
psqlpostgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Postgresql user permissions to database

sudo -u postgres 
psqlpostgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

-1

Source: medium.com

Similar codes

39 votes190 views6 answers
Rm directory ubuntu
Shell/Bash
3 votes212 views1 answer
Linux give full permission to directory
Shell/Bash
2 votes283 views2 answers
Create file linux
Shell/Bash
19 votes274 views2 answers
Install openjdk 8 debian 10
Shell/Bash
11 votes224 views1 answer
Install intellij idea on ubuntu 20.04
Shell/Bash
1 vote193 views3 answers
Cordova could not install from "android" as it does not contain a package.json file.
Shell/Bash
1 vote186 views1 answer
Git autocomplete branch name mac
Shell/Bash
1 vote226 views1 answer
Initialize nx environment
Shell/Bash
0 vote209 views1 answer
How to unzip gzip files in terminal
Shell/Bash
22 votes190 views6 answers
Add python to path
Shell/Bash