/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

1 vote280 views1 answer
Rpi-update specific kernel version
Shell/Bash
3 votes310 views1 answer
Lua reverse shell
Shell/Bash
0 vote294 views1 answer
Debian buster install twemproxy
Shell/Bash
1 vote325 views1 answer
Iterm ftp command not found
Shell/Bash
1 vote296 views1 answer
How to get monitor size from terminal
Shell/Bash
0 vote322 views1 answer
How to compress all branches on branch into one branch back to the master
Shell/Bash
0 vote312 views1 answer
Xargs example with curl
Shell/Bash
0 vote304 views2 answers
Debian install sbatch
Shell/Bash
0 vote311 views1 answer
Ssh key to ppk linux
Shell/Bash
1 vote314 views1 answer
Error: pcap library not found!
Shell/Bash