/SQL/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

8 votes297 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote283 views1 answer
How to move a column to different spot mysql
SQL
4 votes281 views1 answer
Sql quote in string
SQL
0 vote288 views1 answer
Sql server insert inner join
SQL
0 vote253 views1 answer
Postgresql import data from csv
SQL
0 vote295 views1 answer
Create a sql server database programmatically
SQL
0 vote267 views1 answer
Show all mongodb
SQL
0 vote304 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote267 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
1 vote272 views1 answer
Oracle rolling back transactions
SQL