Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
REVOKE Statement (SQL) (m691508+revoke.htm)
Revokes privileges for a particular table from users. Reverses the action of the GRANT statement.
REVOKE [ ALL
|| revoke-privilege {, revoke-privilege{...}}
] ON table-name FROM [ PUBLIC
|| user-name
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.
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
REVOKE DELETE ON EMP FROM admin
REVOKE ALL ON EMP FROM PUBLIC