Grant permission in postgres

Grant all privileges database postgres to user

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username;

Source: tableplus.com

Grant permission in postgres

GRANT ALL PRIVILEGES ON DATABASE db_name TO username;

Grant all privileges database postgres to user

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA schema_name TO username;

Source: tableplus.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;

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

2 votes353 views2 answers
Sql strip non alphanumeric characters
SQL
2 votes370 views1 answer
Coalesce sql
SQL
0 vote374 views1 answer
Sql query to force the database to be drop
SQL
0 vote308 views1 answer
How to get last client id sql
SQL
11 votes353 views5 answers
Sql server reset identity
SQL
0 vote325 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
1 vote377 views1 answer
Sql select whole row max column
SQL
0 vote381 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote408 views1 answer
Osm2pgsql mac
SQL
0 vote344 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL