Revoking privileges on materialized views

To grant privileges on materialized views, log in as:
  • The materialized view owner

  • The owner of the Schema that contains the materialized view

  • The Security Administrator

  • The SUPER.SUPER user if the Security Administrator group is empty

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 > Catalogs > Schemas.
  3. Select the required schema.
  4. In the right pane, click the Materialized Views tab.

    Or, click the Materialized Views folder in the navigation tree.

  5. Right-click on a materialized view, and select Grant/Revoke Privileges.

    The Grant option is selected by default.

  6. Click Revoke.
  7. In the Grantee section, select Public to revoke privileges from all users.

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

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

  8. Optional. In the user grid, select the required user name to select a user.

    Or, press Ctrl and click the desired user names to select multiple users.

  9. Optional. To revoke privileges on behalf of another user, select By User option and select the user name in the corresponding drop-down menu.
  10. Click Revoke.