REVOKE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The REVOKE statement removes database privileges granted to the specified users or public. You cannot revoke privileges granted by other users.
For more information about privileges, see
GRANT.
The REVOKE statement has the following format:
[EXEC SQL] REVOKE [GRANT OPTION FOR]
ALL [PRIVILEGES] | privilege {, privilege}
[ON [TABLE] [schema.]table_name
FROM PUBLIC | auth_id {, auth_id}
[CASCASE | RESTRICT];
privilege
Specifies the privilege to revoke. To revoke all privileges, use ALL. The privileges must be one of the following:
• Select
• Update
• Insert
• Delete
• References
table_name
Specifies the name of the table on which the privileges were granted.
auth_id
Specifies the authorization identifier from which privileges are being revoked.
Last modified date: 08/14/2024