5 The User Management Page
Available only if you signed in as a database user with the DBA,
PDB_DBA, CONNECT, and RESOURCE roles granted as DEFAULT
roles.
The User Management page enables you to perform user management tasks such as create, edit, enable REST, and delete users.
To access the User Management page, click 
on the top left of the application. In the left pane, select Admin, and
then select User Management.
The User Management page consists of two parts: Current User and All Users
Current User
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 the Copy to Clipboard icon to copy the URL to the user's clipboard.
Click 
to open the context menu. The actions available are the following:
-
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
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.
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 using the following icons:
(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.
5.1 The Create/Edit User Dialog
This dialog is used for creating a new database user or editing an existing database user.
-
To create a new database user, click Create User in the User Management page.
-
To edit an existing database user, select Edit from the context menu for the associated user.
The user properties are grouped under two tabs: User and Granted Roles.
User Tab
Specifies general properties for the database user.
-
User Name: The user name string. For an existing user, this field is read-only. To change the name, you must drop the user and create a new user with the desired name.
-
New Password: Password string for the new user, or new password for an existing user. You must also type the same password string for Confirm Password.
-
Password Expired: If this option is selected, the password is marked as expired, and the user must change the password before being permitted to connect to the database.
-
Account is Locked: If this option is selected, the user will not be permitted to connect to the database until a DBA user unlocks the account associated with this user.
-
REST Enable: If this option is selected, the user is enabled for REST. Enter the related fields: Alias, URL Mapping Type and Authorization required. These options are also available in the REST Enable dialog.
Granted Roles Tab
Specifies roles to be granted to the user. For each role, you can check Granted to grant the role, Admin to permit the user to grant the role to other users, and Default to use the default settings for Granted and Admin. By default, a new user is granted CONNECT and RESOURCE roles as Default roles.
5.2 The REST Enable User Dialog
The dialog is used to enable REST for a user that has not been REST enabled. Select Enable REST from the user context menu in the User Management page to open the REST Enable User dialog.
When you select Enable REST for a user for the first time, the REST Enable User dialog is displayed. Subsequently, if you disable REST and then select Enable REST again, you receive a message stating that REST is enabled. In this case, the REST data previously provided is used for enabling REST. To enter new REST data, select Drop REST Services and then select Enable REST again.
Schema Alias: Enter the alias for the schema name to use in the URL.
URL Mapping Type: Select BASE_PATH or BASE_URL.
Authorization Required: For a schema, controls whether Oracle REST Data Services should require user authorization before allowing access to the Oracle REST Data Services metadata catalog of this schema.
5.3 The Delete User Dialog
This dialog is used to delete users. To delete a user, select Delete from the user context menu in the User Management page to open the Delete User dialog.
-
Cascade: If this option is selected, all dependent objects are also deleted.
-
Drop REST Services: If this option is selected, all user REST data is removed from ORDS.
Note:
If you do not select this option when deleting a user, the next time you create a user with the same user name, it will still retain the REST-enabled property.
Click Delete User and a confirmation or error notification is displayed.