doc-exports/docs/dws/tool/DWS_DS_117.html
Lu, Huayi 346ac31da9 DWS TG 8.1.3.200 VERSION
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Reviewed-by: Jiang, Beibei <beibei.jiang@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-08-28 09:20:17 +00:00

4.9 KiB

Working with Users/Roles

You can perform the following operations on an existing user/role:

Dropping a User/Role

Follow the steps below to drop a user/role:

  1. Right-click the selected user/role and select Drop User/Role.

    The Drop User/Role dialog box is displayed.

  2. Click Yes to drop the user/role.

    The status bar displays the status of the completed operation.

Viewing/Editing User/Role Properties

Follow the steps below to view the properties of a user/role:

  1. Right-click the selected user/role and select Properties.

    Data Studio displays the properties (General, Privilege, and Membership) of the selected user/role in different tabs.

    Editing of properties can be performed. OID is a non-editable field.

    Refer to Editing Table Data for information on edit, save, cancel, copy, and refresh operations.

Viewing the User/Role DDL

Follow the steps below to view the DDL of a user/role:

  1. Right-click the selected user/role and select Show DDL.

    The user/role DDL is displayed in a new SQL Terminal tab. You must refresh the Object Browser to view the latest DDL.