Create Database Users
To create users in your database, connect to the database as the ADMIN user using any SQL client tool.
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 usernew_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.