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

GRANT Non-SQL Definition Privilege Authorization

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

• Grantable privilege on the non-SQL-defined schema (you can grant the privilege, but you cannot specify WITH GRANT OPTION).
• DBADMIN on the dictionary containing the non-SQL-defined schema definition.
• SYSADMIN.

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