okram999 · July 30, 2019 14:14
diff --git a/Adding a user or granting access b/Adding a user or granting access
 Create new user: 	CREATE USER <userid> WITH PASSWORD <password>;
 User should change password  after login:	ALTER ROLE your_userid WITH PASSWORD 'new_password'; 
 Create a role:	CREATE ROLE < Role Name> 
 Grant PRIVILEGES to Role:	GRANT SELECT ON all tables in schema public to  <role_name>
 Assign role to user:	GRANT <Role Name> TO <User Id>;
 Revoke  permissions:	REVOKE <userId> FROM <role name>;
	Create new user: CREATE USER <userid> WITH PASSWORD <password>;
	User should change password after login: ALTER ROLE your_userid WITH PASSWORD 'new_password';
	Create a role: CREATE ROLE < Role Name>
	Grant PRIVILEGES to Role: GRANT SELECT ON all tables in schema public to <role_name>
	Assign role to user: GRANT <Role Name> TO <User Id>;
	Revoke permissions: REVOKE <userId> FROM <role name>;