Postgres: To create a new user (also called role)

 CREATE ROLE  read_only_user LOGIN PASSWORD 'secure_password';

Grant the necessary privileges for the new user to connect to your
database:

GRANT CONNECT ON DATABASE exampledb TO read_only_user;
GRANT USAGE ON SCHEMA public TO read_only_user;

alter role  eisuser with login;

 CREATE ROLE  pan187 LOGIN PASSWORD 'tempPwd_1';



GRANT CONNECT ON DATABASE cfperf TO pts304;
GRANT usage ON SCHEMA cfadmin TO pts304;
GRANT USAGE ON SCHEMA cfaudit TO pts304;
GRANT USAGE ON SCHEMA cmsadmin TO pts304;
GRANT USAGE ON SCHEMA cmtadmin TO pts304;
GRANT USAGE ON SCHEMA ctlgadmin TO pts304;
GRANT USAGE ON SCHEMA ctlgadmin2 TO pts304;
GRANT USAGE ON SCHEMA grpadmin TO pts304;
GRANT USAGE ON SCHEMA invadmin TO pts304;
GRANT USAGE ON SCHEMA ordadmin TO pts304;
GRANT USAGE ON SCHEMA seadmin TO pts304;
GRANT select,insert,update,delete ON all tables in schema cfadmin TO pts304;
GRANT select,insert,update,delete ON all tables in  SCHEMA cfaudit TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA cmsadmin TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA cmtadmin TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA ctlgadmin TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA ctlgadmin2 TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA grpadmin TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA invadmin TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA ordadmin TO pts304;
GRANT select,insert,update,delete ON all tables in SCHEMA seadmin TO pts304;