/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

5 votes175 views1 answer
Alter table default value mysql
SQL
0 vote202 views1 answer
Create table Statement Syntax in SQL Server
SQL
18 votes237 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
2 votes201 views3 answers
Mysql pass command from command line
SQL
1 vote198 views3 answers
Union SQL
SQL
0 vote213 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote216 views2 answers
Timing sql queries
SQL
0 vote223 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote209 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote189 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL