DevOps
GRANT commands in PostgreSQL allow a user to assign privileges on a database object to other users. Syntax: GRANT privilege_name ON object_type object_name TO role_name;
Ex: GRANT SELECT ON table sales TO user_read;
Revoking privileges is done using REVOKE command.
Tuesday January 31, 2023