/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

0 vote384 views1 answer
Debian buster enable rc.local
Shell/Bash
0 vote359 views1 answer
Wsl2 have systemctl ?
Shell/Bash
2 votes338 views2 answers
Fsl reg
Shell/Bash
0 vote375 views1 answer
Install caprine linux
Shell/Bash
0 vote370 views1 answer
Htpasswd add user
Shell/Bash
0 vote371 views1 answer
Run command every hour linux
Shell/Bash
90 votes348 views6 answers
Show remote git
Shell/Bash
99 votes372 views6 answers
Npm update latest version
Shell/Bash
1 vote381 views2 answers
Fix SSH Error in Terminal & Linux: client_loop: send disconnect: Broken pipe
Shell/Bash
0 vote371 views1 answer
Powershell create folder recursively
Shell/Bash