Create Users on Autonomous Database

There are several options to create users on Autonomous Database. You can use Oracle Database Actions User Management or use client-side tools that connect to the database to create database users.

Create Users on Autonomous Database - Connecting with SQL Developer Web

You can quickly create Autonomous Database users with Oracle Database Actions.

First, access SQL Developer Web as the ADMIN user. See Access SQL Developer Web as ADMIN for more information.
  1. Click the top left navigation iconnext to Oracle Database Actions.

    This shows the Database Actions menu, including Actions and Administration.

  2. Click Administration and then select User Management.
  3. On the User Management page, in the All Users area click Create User.

    This shows the Create User dialog where you enter a user name, password, and account options for a new user.

  4. To create a new user, enter a user name and a password and enter the password again to confirm the password.
  5. (Optional) If you want to grant roles for the new user, click the Granted Roles tab and select the roles for the user. For example, select DWROLE and CONNECT.
  6. Click Create User.

    Database Actions shows the User Created confirmation dialog.

  7. Click OK.

This creates a new user. See Manage User Roles and Privileges on Autonomous Database to add or update privileges for a user, such as privileges for connecting, creating tables, and creating views.

See The User Management Page for information on Database Actions User Management.

If you REST enable the new user you create, then to provide the user with Web access to the database you need to send a URL. See Provide SQL Developer Web Access to Database Users for more information.

The administrator needs to provide the credentials wallet to the new user for client-side access. See Connecting to Autonomous Data Warehouse for more information on client-side access credentials.

Note:

Autonomous Data Warehouse requires strong passwords; the password you specify must meet the default password complexity rules. See About User Passwords on Autonomous Database for more information.

See Create Oracle Application Express Workspaces in Autonomous Data Warehouse for information on creating APEX workspaces.

See Create and Update User Accounts for Oracle Machine Learning Notebooks to add user accounts for Oracle Machine Learning Notebooks.

Create Users on Autonomous Database - Connecting with a Client Tool

You can create users by connecting to the database as the ADMIN user using any SQL client tool.

For example, connect using Oracle SQL Developer (see Connect with Oracle SQL Developer (18.2 or later)).

  1. Connect as the ADMIN user.
  2. Run the following SQL statements:
    CREATE USER new_user IDENTIFIED BY password;
    GRANT CREATE SESSION TO new_user;

    Note:

    IDENTIFIED with the EXTERNALLY clause is not supported with Autonomous Database.

    In addition, IDENTIFIED with the BY VALUES clause is not allowed.

This creates new_user with connect privileges. This user can now connect to the database and run queries. To grant additional privileges to users, see Manage User Roles and Privileges on Autonomous Database.

The administrator needs to provide the credentials wallet to the user new_user. See Connecting to Autonomous Data Warehouse for more information on client credentials.

Note:

Autonomous Data Warehouse requires strong passwords; the password you specify must meet the default password complexity rules. See About User Passwords on Autonomous Database for more information.

See Provide SQL Developer Web Access to Database Users to add users for SQL Developer Web.

See Create Oracle Application Express Workspaces in Autonomous Data Warehouse for information on creating APEX workspaces.

See Create and Update User Accounts for Oracle Machine Learning Notebooks to add user accounts for Oracle Machine Learning Notebooks.

Unlock User Accounts on Autonomous Database

If a user account is locked, as the ADMIN user you can unlock the account.

To unlock an account, connect to your database as the ADMIN user and run the following command:

ALTER USER username IDENTIFIED BY password ACCOUNT UNLOCK;

See SQL Language Reference for information on the ALTER USER command.

About User Passwords on Autonomous Database

Autonomous Data Warehouse requires strong passwords; the password you specify for a user must meet the following default password complexity rules:

  • The password must be between 12 and 30 characters long and must include at least one uppercase letter, one lowercase letter, and one numeric character.

    Note, the password limit is shown as 60 characters in some help tooltip popups. Limit passwords to a maximum of 30 characters.

  • The password cannot contain the username.

  • The password cannot be one of the last four passwords used for the same username.

  • The password cannot contain the double quote (") character.

  • The password must not be the same password that is set less than 24 hours ago.

To change the password complexity rules and password parameter values you can alter the default profile or create a new profile and assign it to users. See Manage User Profiles with Autonomous Database for more information.

The following are the Autonomous Database default profile password parameter values:

Password Parameter Description Value
PASSWORD_GRACE_TIME

The number of days after the grace period begins during which a warning is issued and login is allowed.

30
PASSWORD_LIFE_TIME

The number of days the same password can be used for authentication.

360
PASSWORD_LOCK_TIME

The number of days an account will be locked after the specified number of consecutive failed login attempts

1
PASSWORD_REUSE_MAX

The number of password changes required before the current password can be reused.

4
PASSWORD_REUSE_TIME

The number of days before which a password cannot be reused.

1

See Manage User Profiles with Autonomous Database for information on using CREATE USER or ALTER USER with a profile clause.

See SQL Language Reference for information on the ALTER USER command.