Revoking privileges on a view

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

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, navigate to the Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand the Views folder and select the view for 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 Revoke to revoke privileges.
  6. Optional. In the Operation section, select the All Privileges check box to revoke all privileges.

    If the All Privileges option is selected, the options in the View 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, the user grid is enabled. Press Ctrl and click on the desired user names to select users.

  9. Optional. Select By User and select the user name in the corresponding drop-down menu to revoke privileges on behalf of another user.

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

  10. Select the desired options in the View Privileges section.

    The available options are Select, Insert, and Delete.

  11. In the Column Reference Privileges section:

    • Select All Column to grant reference privilege on all columns.

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

      If Specified Columns is selected, the list of columns is enabled. Press Ctrl and click on the desired column names to select columns.

    • Select No Columns to not revoke any reference privileges.

  12. In the Column Update Privileges section:

    • Select All Column to grant update privilege on all columns.

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

      If Specified Columns is selected, the list of column names is enabled. Press Ctrl and click on the desired column names to select columns.

    • Select No Columns to not revoke update privileges.

  13. Click Revoke.