Roles and Privileges

  • System Privileges: e.g., CREATE TABLE
  • Object Privileges: e.g., SELECT on a table
CREATE ROLE read_only;
GRANT SELECT ON employees TO read_only;
GRANT read_only TO analyst;