Answers for "postgres create user with role"

how to create a new user in postgresql

CREATE DATABASE yourdbname;CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;

Posted by: Guest on July-03-2020

postgresql create user roles

CREATE ROLE admin WITH CREATEDB CREATEROLE;

Posted by: Guest on July-22-2020

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 "postgres create user with role"