Revoking create schema privilege

Prerequisites
To revoke 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

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, select Database > My Systems.
  3. Right-click on a catalog and select Grant/Revoke Privileges.
  4. In the Operation section, select Revoke.
  5. In the Grantee section, select the desired user name.

    To select multiple owners, press Ctrl and click the desired user names.

  6. Click Revoke.