1. Using Guide for On-Premises Oracle Database
  2. Administration
  3. The Database Users Page
  4. Creating or Editing a User

10.1 Creating or Editing a User

You can create a new database user or edit an existing database user.

  • To create a new database user, click Create User in the Database Users 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.

  • 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.

  • Quota on tablespace USERS: Enter or select to assign quota on the user’s default tablespace. By default, the user has no quota on the default tablespace.

  • Web Access: If this option is selected, the user is enabled for REST access. Expand Web access advanced features to specify the related fields: Authorization required, REST Alias, and URL Mapping Type.

Granted Roles Tab

Specifies roles to be granted to the user.

Use Filter by role to quickly locate the required roles.

For each role, you can select 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. A new user is granted CONNECT and RESOURCE roles when Web Access is selected.

Show code: Select this option to view the PL/SQL code equivalent of the Create/Edit User slider. You can copy and execute this PL/SQL code in the worksheet to perform the same action that occurs when you click Create/Edit in the Create/Edit User slider.