Granting/Revoking a Privilege

Follow the steps below to grant/revoke a privilege:

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

   The Grant/Revoke dialog box is displayed.

2. Select the objects to grant/revoke a privilege from the Object Selection tab and click Next.
3. Select the role from the Role drop-down list in the Privilege Selection tab.
4. Select Grant/Revoke in the Privilege Selection tab.
5. Select/unselect the required privileges in the Privilege Selection tab.

   In the SQL Preview tab, you can view the SQL query automatically generated for the inputs provided.

6. Click Finish.