If you create or restore a database in Oracle, the software creates the user with a DEFAULT profile.
To verify the password, you can add the password verification function to the DEFAULT profile. The password verification function is delivered with the product. The password:
-
Must be different from the username
-
Cannot begin or end with a number
-
Must contain at least two embedded numbers
-
Must contain at least one uppercase and lowercase letter
-
Must be at least 8 characters and should not exceed 15 characters
-
Cannot use any of the following combinations - welcome, database, account, user, password, oracle, computer, and abcd.
Enable the Password Verification Function on the Server
The Oracle database administrator is responsible for modifying and enabling the password verification function.
-
On the server, run the OraclePasswordVerification.sql application available at [Product Folder]\ProjectMgmt\Server\Schema\Oracle.
The application creates a PASSWORDCHECK function under the [Oracle Service] > Functions node.
-
Select a DEFAULT profile, and then run the following query:
"Alter profile default limit PASSWORD_VERIFY_FUNCTION PASSWORDCHECK;"
Commit;
The default profile Limit is set to PASSWORDCHECK, indicating that the profile is ready with the password verification.