Grant/Revoke Privilege¶
Follow the steps below to grant/revoke a privilege:
Right-click the sequences group and select Grant/Revoke.
The Grant/Revoke dialog is displayed.
Select the objects to grant/revoke privilege from the Object Selection tab and click Next.
Select the role from Role drop-down list in the Privilege Selection tab.
Select Grant/Revoke in the Privilege Selection tab.
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.
Click Finish.