Snippet

Withdrawing Data Modification Rights with REVOKE

The REVOKE command removes a specific database privilege previously granted to a user, reinforcing security and access restrictions.

snippet.sql

sql

REVOKE INSERT ON orders
FROM audit_user;

Breakdown

REVOKE INSERT ON orders

Specifies the withdrawal of permission to insert new rows into the orders table.

FROM audit_user;

Designates audit_user as the user losing the INSERT privilege.