Granting/Revoking a Privilege

Follow the steps below to grant/revoke a privilege:

Right-click the schema group and select the 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 the Role drop-down in the Privilege Selection tab.
Select Grant/Revoke in the Privilege Selection tab.
Select/unselect the required privileges in the Privilege Selection tab.

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

Parent topic: Schemas

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center