Answers for "create role and grant privileges in postgres"

how to give access to database in postgresql server to another user

GRANT permissions ON DATABASE dbname TO username;

Posted by: Guest on June-17-2020

postgresql change user role grant

=# ALTER USER librarian WITH SUPERUSER;
ALTER ROLE

Posted by: Guest on July-22-2020

how to add user to role postgresql

CREATE ROLE joe LOGIN INHERIT;
CREATE ROLE admin NOINHERIT;
CREATE ROLE wheel NOINHERIT;
GRANT admin TO joe;
GRANT wheel TO admin;

Posted by: Guest on January-27-2021

how to add user to role postgresql

GRANT group_role TO role1, ... ;
REVOKE group_role FROM role1, ... ;

Posted by: Guest on January-27-2021

Code answers related to "create role and grant privileges in postgres"