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.

Parent topic: Users/Roles