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

GRANT SQL Definition Privileges Authorization

To grant definition privileges on SQL-defined database resources, one of the following must be true:

• You hold the corresponding grantable privilege on the resource (you can grant the privilege, but you cannot specify WITH GRANT OPTION).
• You own the resource.
• You hold DBADMIN on the dictionary containing the definition.
• You hold SYSADMIN privilege.