Granting/Revoking Privileges

The batch grant/revoke operation allows you select multiple objects to grant/revoke privileges. You can also perform batch grant/revoke operation on searched objects.

This feature is only available for OLAP, not for OLTP.

Note

Batch grant/revoke is allowed only with the same object type within that schema.

Follow the steps to grant/revoke privileges in a batch:

  1. Press Ctrl+left-click (select objects one by one) or Shift+left-click (select objects in a bunch) to select the objects to grant/revoke privileges.

  2. Right-click and select Grant/Revoke.

    Grant/Revoke dialog box is displayed.

  3. Refer to Granting/Revoking a Privilege section to grant/revoke privilege.