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 votes287 views1 answer
Remove root password mysql
SQL
0 vote288 views1 answer
Using distinct and count together in sql
SQL
0 vote280 views1 answer
Install postgresql 12 on debian 10
SQL
20 votes275 views2 answers
Mysql bigint max value
SQL
0 vote273 views2 answers
Postgresql get long running queries
SQL
0 vote269 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote297 views2 answers
How to combine 2 tables in MySQL
SQL
16 votes286 views6 answers
Mysql find and replace
SQL
0 vote301 views2 answers
Mysql on update current_timestamp
SQL
0 vote284 views1 answer
Character count sql
SQL