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

4 votes359 views2 answers
Oracle unlock user
SQL
5 votes358 views2 answers
Postgre insert select
SQL
0 vote337 views1 answer
How to check if there is no database schema
SQL
0 vote343 views1 answer
Renommer schema sql
SQL
0 vote373 views1 answer
Excel export from sql using python
SQL
2 votes399 views2 answers
Create temporary table in mysql
SQL
5 votes353 views2 answers
Copy data from one database to another
SQL
0 vote344 views1 answer
PSQL qith variables
SQL
-2 votes346 views1 answer
Remove root password mysql
SQL
0 vote341 views1 answer
Postgresql print variable
SQL