Granting/Revoking a Permission (Function/Procedure)

Perform the following steps to grant or revoke a permission:

1. Right-click functions/procedures group and select the Grant/Revoke.

   The Grant/Revoke dialog box is displayed.

2. Select the objects to grant/revoke privilege from the Object Selection tab and click Next.

   The Privilege Selection tab is displayed.

3. Select the role from the Role drop-down list.
4. Select Grant/Revoke.
5. Select or deselect the required permissions.

   The SQL Preview tab displays the SQL query automatically generated for the inputs provided.

6. Click Finish.