sql / intermediate
Snippet
Removing Table Update Privileges using REVOKE
The REVOKE statement in ANSI SQL is used to revoke previously granted access permissions or privileges from user accounts or database roles, adhering to the principle of least privilege for access control.
snippet.sql
sql
1
REVOKE UPDATE ON employees FROM analyst_role;
Breakdown
1
REVOKE UPDATE ON employees FROM analyst_role;
Removes data modification (UPDATE) authority on the employees table from the analyst_role.