You can grant usage privileges on a selected sequence generator to specific users.
Procedure
Log on to the NonStop SQL/MX Database Manager.
In the navigation tree, navigate to
Schemas folder by expanding
Database > My Systems > Catalogs > Schemas.
Expand
Sequences folder (left pane) or click the Sequences tab (right pane), and select the sequence generator on which you want to grant privileges.
Right-click and select
Grant/Revoke Privileges.
The grant/revoke privileges options appear in the right pane. The
Grant option is selected by default.
Grant/revoke privileges
In the
Grantees section, select
Public to grant privileges to all users.
Or, select
Specified Users option to grant privileges to 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 granted on a sequence generator is usage.
Optional. In the user grid, press
Ctrl and click on the desired user names to select users.
Optional. Select
By User option and select the user name in the corresponding drop-down menu to grant privileges to that user.
Optional. Select
With Grant Option to grant the privileges and allow the grantees to grant the privileges to other users.
