OpenSQL Reference Guide > OpenSQL Reference Guide > Extended Statements > REVOKE
Was this helpful?
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: 01/30/2023