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 vote292 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote278 views1 answer
Psql datestyle
SQL
0 vote317 views1 answer
Mysql dump for selected row
SQL
0 vote271 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
3 votes306 views4 answers
Truncate syntax in sql
SQL
1 vote287 views1 answer
How to delete data from sql database in android
SQL
93 votes368 views4 answers
Create database postgres
SQL
0 vote260 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
2 votes282 views4 answers
Sql query interview questions
SQL
0 vote320 views1 answer
Drop a view in sqlite
SQL