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

REVOKE INSERT ON employees FROM analyst_role;

Breakdown

REVOKE INSERT ON employees FROM analyst_role;

Removes the permission to insert new rows into the employees table from analyst_role.

Previous snippet Next snippet

More Beginner SQL exercises →

Revoking Access Permissions from Users with REVOKE

Related