/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

0 vote169 views1 answer
Oracle drop default value
SQL
0 vote181 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote220 views1 answer
Cahnge column name apex oracle
SQL
0 vote169 views1 answer
How to select only id where is not in column mysql
SQL
0 vote261 views1 answer
Linux upload database to mysql
SQL
0 vote175 views1 answer
Qt qsql check if table exist
SQL
0 vote189 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote194 views1 answer
Oracle cpu metric
SQL
0 vote206 views1 answer
000webhost database values insert
SQL
0 vote276 views1 answer
Site:av.ru "files"
SQL