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

0 vote150 views1 answer
Mysql exception output
SQL
7 votes153 views1 answer
Alter sequence set current value oracle
SQL
7 votes148 views3 answers
Python and mysql connectivity
SQL
1 vote150 views1 answer
Float precision in psql
SQL
2 votes136 views3 answers
How to pass password mysql command line
SQL
1 vote139 views1 answer
Python escape mysql
SQL
1 vote163 views1 answer
How do you use sql in you company
SQL
24 votes135 views4 answers
How to add column sql
SQL
0 vote155 views1 answer
Create a plsql object
SQL
1 vote146 views1 answer
Best configuration for display table in sqlplus
SQL