sql / beginner
Snippet
Revoking Access Permissions from Users with REVOKE
The REVOKE command removes specific privileges previously granted to database users or roles. This helps enforce security policies by restricting authorization to write or modify table data.
snippet.sql
sql
1
REVOKE INSERT ON employees FROM analyst_role;
Breakdown
1
REVOKE INSERT ON employees FROM analyst_role;
Removes the permission to insert new rows into the employees table from analyst_role.