🔐 Access Control
GRANT, REVOKE and role management for schemas.
| Snippet | |
|---|---|
| ☆GRANT SELECT — Give read access on a table |
GRANT SELECT ON employees TO hr_user;
|
| ☆REVOKE UPDATE — Take back a privilege |
REVOKE UPDATE ON salaries FROM temp_user;
|
| ☆CREATE ROLE — Named bundle of privileges |
CREATE ROLE analyst_role;
|
| ☆GRANT ROLE — Give a role to a user |
GRANT analyst_role TO hr_user;
|