revoke

Takes a privilege back.

Syntax

revoke PRIVILEGE on TABLE_NAME from USERNAME;
revoke all [privileges] on TABLE_NAME from USERNAME;
revoke dba from USERNAME;

• The privileges are ALL, ALTER, DELETE, DROP, DUMP, EXECUTE, INSERT, LOCK, SELECT, TRUNCATE and UPDATE.
• You must own the table, or use an administrator account.
• revoke dba moves the user back to the users group. Only an administrator can use it, and nobody can revoke their own DBA privilege.

revoke select on gaia_source from claude;