doc-exports/docs/dws/tool/DWS_DS_59.html
Lu, Huayi 4194b50d78 DWS TOOL 811 version
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2022-12-14 20:46:26 +00:00

3.1 KiB

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.

This feature is only supported in online analytical processing (OLAP), not in online transaction processing (OLTP).