8 The User Management Page

Available only if you signed in as a database user with the DBA and PDB_DBA roles.

The User Management page enables you to perform user management tasks such as create, edit, enable REST, and delete users.

To reach the User Management page, click User Management in the Database Actions page, or click Selector and select User Management from the Administration menu in the navigation pane.

The User Management page consists of two parts: Current User and All Users.

Current User

Description of the illustration current_user.jpg

Displays information about the current user such as user name, whether REST Enabled or not, REST Alias, account expiration (in days), and the last login date and time. The icon on the left displays the user status with one of the following colours: green (Open), blue (Locked), and red (Expired).

The URL at the bottom is displayed only if the user is REST Enabled. It provides the URL to the SQL Developer Web user login page. Use Copy to Clipboard to copy the URL to the user's clipboard.

Click Object submenu to open the context menu. The actions available are:

• Edit: Opens the Edit User Dialog, where you can edit current user information. See The Create/Edit User Dialog.

• Enable REST: Enables REST for a user where disabled. When this option is selected the first time, it opens the Enable REST dialog. See The REST Enable User Dialog.

• Disable REST: Disables REST where enabled for a user.

• Drop REST Services: Removes the REST data for a user, such as REST Alias, Base Path and so on, which is stored in Oracle REST Data Services (ORDS).

• Delete: Opens the Delete User dialog, where you can delete the user. See The Delete User Dialog.

All Users

Description of the illustration all_users.jpg

Displays information about all other users that have been created in the database. You can use the Search field, which is case insensitive, to search for users, or sort the users in ascending or descending order using the sort icons, or filter by user status or REST status.

To create a user, click Create User to open the Create User dialog. For more information, see The Create/Edit User Dialog.

There are two views available:

(Card View): Displays the user information in a card view. This is the default display view. Each user card provides details such as user status, password expiry, user name, and the context menu.

(Grid View): Displays the user information in a tabular format. The last column in each row contains the context menu icon.