Snippet

Removing Direct Table Modification Rights with REVOKE

The REVOKE command removes specific database permissions from users or roles, enforcing the principle of least privilege for security compliance.

snippet.sql

sql

REVOKE UPDATE, DELETE ON audit_logs FROM analyst_role;

Breakdown

REVOKE UPDATE, DELETE

Specifies the write modification permissions being withdrawn.

ON audit_logs

Identifies the target database table audit_logs.

FROM analyst_role;

Designates the role losing these specific table permissions.