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:
Right-click the selected user/role and select Drop User/Role.
The Drop User/Role dialog box is displayed.
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:
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:
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.