Syntax
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.