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:
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.
Right-click and select Grant/Revoke.
Grant/Revoke dialog box is displayed.
Refer to Granting/Revoking a Privilege section to grant/revoke privilege.