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

Authorization

To revoke a definition privilege on a DMCL or DBTABLE, you must hold one of these privileges:

• The corresponding grantable privilege
• DBADMIN on DB SYSTEM
• SYSADMIN

To revoke a physical definition privilege on a database, you must hold one of these privileges:

• The corresponding grantable privilege
• DBADMIN on the database
• SYSADMIN

You must be connected to the system dictionary when you issue the statement.