REVOKE Statement
Revokes privileges for a particular table from users. Reverses the action of the GRANT statement.
Syntax
REVOKE [ ALL
|| revoke-privilege {, revoke-privilege{...}}
] ON table-name FROM [ PUBLIC
|| user-name
Syntax Elements
revoke-privilege =
DELETE || INSERT ||
SELECT || UPDATE
table-name =
{owner-name.}table-identifier
owner-name
The SQL user-id of the creator of the table.
table-identifier
The name of the required table.
user-name
The SQL user-id of the user for whom privileges are to be revoked.
Restrictions
Only the SQL owner of the table can perform this statement. The owner of the table must have SQL Catalog Maintenance privilege set in the Reality security profile
Examples
REVOKE DELETE ON EMP FROM admin
REVOKE ALL ON EMP FROM PUBLIC