Granting create catalog or Security Administrator privileges

You can grant create catalog or Security Administrator privileges on a system for specific users. For more information on privileges, see the HPE NonStop SQL/MX Reference Manual.

Prerequisites
To grant create catalog or Security Administrator privileges, log in as the Security Administrator or the SUPER.SUPER user if the Security Administrator group is empty.

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. Right-click on a system and select Grant/Revoke Privileges.

    The Grant option is selected by default.

    Granting create catalog or Security Administrator privileges
  3. In the Privileges section:

    • Select Create Catalog to grant create catalog privileges.

    • Select Security Administrator to grant security administrator privileges.

  4. In the Grantee section, select the desired user name.

    Or, press Ctrl and click to select multiple users.

  5. Click Grant.