Revoking privileges on a table

You can revoke the following privileges on a table from specific users: select, insert, delete, column reference, and column update.

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.

    To revoke privilege on a table, log in as the owner of the table, the security administrator, or as SUPER.SUPER user if the Security Administrator group is empty.

  2. In the navigation tree, navigate to Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand Tables folder (left pane) and select the table 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.

  5. Select the Revoke option to revoke privileges.
  6. Optional. In the Operation section, select All Privileges check box to revoke all privileges.

    If the All Privileges option is selected, then the options in the Table Privileges, Column Reference Privileges, and Column Update Privileges sections are disabled.

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

    Or, select Specified Users to revoke privileges from specific users.

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

  9. Optional. In the user grid, press Ctrl and click on the desired user names to select users.
  10. Optional. In Grantor section, select By User option and select the user name in the corresponding drop-down menu to revoke privileges on behalf of another user.

    Select Cascade option to revoke dependent privilege descriptors and objects. If cascade is not selected, Revoke is executed with RESTRICT option.

  11. Optional. Select With Grant Option to grant privileges and allow the grantees to revoke the selected privileges from other users.
  12. In the Column Reference Privileges section, select one of the following options:
    • Select All Column to revoke reference privilege on all columns.

    • Select Specified Columns to revoke reference privilege on specific columns.

      If the Specified Columns option is selected, then the list of columns is enabled.

    • Press Ctrl and click on the desired column names to select columns.

    • Selecting the No Columns option does not revoke reference privileges.

  13. In the Column Update Privileges section, select one of the following options:
    • Select All Column to revoke update privilege on all columns.

    • Select Specified Columns to revoke update privilege on specific columns.

      If the Specified Columns option is selected, then the list of columns is enabled.

    • Press Ctrl and click on the desired column names to select columns.

    • Selecting the No Columns option does not revoke update privileges.

  14. Click Revoke.