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 vote183 views1 answer
Set root password mysql xampp
SQL
0 vote182 views1 answer
Mysqldump: error:
SQL
0 vote171 views2 answers
Nodejs mysql convert to plain object
SQL
35 votes182 views5 answers
Sql alter column
SQL
8 votes142 views1 answer
Sql remove characters from string right
SQL
0 vote167 views1 answer
Composit key in sql
SQL
0 vote162 views1 answer
Oracle session statistics
SQL
3 votes153 views4 answers
Stop MySQL
SQL
0 vote248 views1 answer
Site:av.ru "files"
SQL
0 vote156 views1 answer
How to set sql_mode for a query in CI model
SQL