Syntax for Securing Database Resources › REVOKE All Table Privileges › Authorization

Authorization

To revoke all table privileges, one of the following must be true:

• You hold all privileges as grantable privileges on the table-like object.
• You own the table-like object.
• You hold DBADMIN privileges for the dictionary that contains the table-like object definition and the database that contains the table-like object data.
• You hold SYSADMIN privilege.