To grant create schema privilege, log in as the Catalog owner, the Security Administrator, or the
SUPER.SUPER user if the Security Administrator group is empty. You can grant create schema privileges on a catalog for specific users. For more information on privileges, see the
HPE NonStop SQL/MX Reference Manual.
Procedure
Log on to the NonStop SQL/MX Database Manager.
In the navigation tree, select
Database > My Systems.
Right-click on a catalog and select
Grant/Revoke Privileges.
The
Grant option is selected by default. In the
Privilege section, the
Create Schema
privilege is selected by default.
In the
Grantee section, select the desired user name.
To select multiple owners, press
Ctrl and click the desired user names.