Syntax for Securing Database Resources › REVOKE Non-SQL Definition Privilege › Authorization

Authorization

To revoke USE privilege on a non-SQL-defined schema, you must hold one of these privileges:

• Grantable USE privilege on the non-SQL-defined schema
• DBADMIN on the dictionary containing the non-SQL schema definition
• SYSADMIN

You must be connected to the dictionary containing the non-SQL-defined schema when you issue the statement.