/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 vote261 views1 answer
Linux traverse all subdirectories and do action
Shell/Bash
0 vote266 views1 answer
Boucle bash
Shell/Bash
2 votes143 views2 answers
Command to delete all files in a directory
Shell/Bash
0 vote207 views1 answer
How to git push in jenkins pipeline
Shell/Bash
2 votes180 views1 answer
Bash uppercase bad substitution
Shell/Bash
0 vote189 views1 answer
Get-docke
Shell/Bash
1 vote254 views1 answer
How to install pakages using ancaonda prompt
Shell/Bash
17 votes195 views1 answer
Install openjdk8 in ubuntu
Shell/Bash
16 votes198 views2 answers
Firebase cli get current project
Shell/Bash
6 votes182 views1 answer
Mongoclient install ubuntu
Shell/Bash