Syntax for Securing Database Resources › REVOKE SQL Definition Privileges › Authorization

Authorization

To revoke a definition privilege for an SQL-defined database resource, one of the following must be true:

• You hold the grantable definition privilege on the resource
• You own the resource
• You hold DBADMIN privilege on the dictionary containing the definitions
• You hold SYSADMIN privilege