Create Database Users

To create users in your database, connect to the database as the ADMIN user using any SQL client tool.

  1. As the ADMIN user run the following SQL statements:
    CREATE USER new_user IDENTIFIED BY password DEFAULT TABLESPACE tablespace_name;
    GRANT CREATE SESSION TO new_user;

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

Note:

The administrator needs to provide the credentials wallet to the user new_user. See Connecting to Autonomous Transaction Processing.

Autonomous Transaction Processing requires strong passwords; the password you specify must meet the 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 unlock a database user account, connect to your database as the ADMIN user and run the following command:

ALTER USER username IDENTIFIED BY password ACCOUNT UNLOCK;

For more information about the ALTER USER command, see Oracle Database SQL Language Reference.