Revoking create catalog or Security Administrator privilege

You can revoke 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 revoke 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.
  3. In the Operation section, select Revoke.
  4. In the Privilege section:

    • Select Create Catalog to revoke create catalog privileges.

    • Select Security Administrator to revoke security administrator privileges.

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

    Or, press Ctrl and click to select multiple users.

  6. Click Revoke.