Granting/Revoking a Permission (Function/Procedure)

Perform the following steps to grant or revoke a permission:

1. Right-click Function/Procedure Group and select Grant/Revoke.

   The Grant/Revoke dialog box is displayed.

2. Open the Object Selection tab to select the desired objects, and click Next.

   The Privilege Selection tab is displayed.

3. Select a 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 after the preceding operations.

6. Click Finish.