Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Granting/Revoking a Privilege
Granting/Revoking a Privilege
Follow the steps to grant/revoke a privilege:
- Right-click functions/procedures group and select the Grant/Revoke.
The Grant/Revoke dialog box is displayed.
- Select the objects to grant/revoke privilege from the Object Selection tab and click Next.
The Privilege Selection tab is displayed.
- Select the role from the Role drop-down list.
- Select the Grant/Revoke.
- Select/unselect the required privileges.
The SQL Preview tab displays the SQL query automatically generated for the inputs provided.
- Click Finish.
This feature is only supported in OLAP, not in OLTP.
Parent topic: Data Studio - Integrated Database Development Tool
Last Article: Editing a Function/Procedure
Next Article: Debugging a PL/SQL Function
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.