Revoking privileges on a sequence generator

You can revoke usage privileges on a selected sequence generator from specific users.

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, navigate to Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand Sequences folder (left pane) or click the Sequences tab (right pane), and select the sequence generator on which you want to revoke privileges.
  4. Right-click and select Grant/Revoke Privileges.

    The grant/revoke privileges options appear in the right pane. The Grant option is selected by default.

  5. Select Revoke to revoke privileges.
  6. Optional. Select Grant Option For to revoke the With Grant Option for the privilege and not the privilege itself.
  7. In the Grantees section, select Public to revoke privileges from all users.

    Or, select Specified Users option in Grantees box to revoke privileges from specific users.

    If Specified Users option is selected, the user grid is enabled.

    In the Privileges section, the Usage option is selected and disabled. This indicates that the only privilege that can be revoked on a sequence generator is usage.

  8. Optional. In the user grid, press Ctrl and click on the desired user names to select users.
  9. Optional. Select By User option and select the user name in the corresponding combo box to revoke privileges on behalf of another user.

    Select Cascade option to revoke dependent privilege descriptors and objects.

  10. Click Revoke.