Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Batch Operation> Granting/Revoking Privileges
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.
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.
Parent topic: Batch Operation
Last Article: Dropping a Batch of Objects
Next Article: Personalizing Data Studio
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.