Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Tables (GaussDB A)> Grant/Revoke Privilege - Regular/Partition Table
View PDF

Grant/Revoke Privilege - Regular/Partition Table

Follow the steps below to grant/revoke a privilege:

  1. Right-click regular tables 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.
  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.
Parent topic: Tables (GaussDB A)