Granting/Revoking a Permission (Function/Procedure)¶
Perform the following steps to grant or revoke a permission:
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 Grant/Revoke.
Select or deselect the required permissions.
The SQL Preview tab displays the SQL query automatically generated for the inputs provided.
Click Finish.
Note
This feature is only supported in OLAP, not in OLTP.