Information
Default passwords should not be used by Oracle database users. Leaving default passwords unchanged can create significant security vulnerabilities by allowing unauthorized access to the database.
Default passwords are widely known and documented. If left unchanged, any malicious user with database access can authenticate using these default credentials, potentially leading to unauthorized data access, privilege escalation, or database compromise.
Solution
To reset the account with NO AUTHENTICATION execute the following SQL statement in CDB:
ALTER USER <USERNAME> NO AUTHENTICATION;
Notes:
- As per Oracle Support Document 2173962.1, newly created database may list SYS and SYSTEM in CBA_USERS_WITH_DEFPWD even if they were set with non-default passwords. Running ALTER USE R with the same password will correctly recognize these accounts as non-default.
- If remote_password_file is set to NONE changing the SYS password via ALTER USER is not possible. In this case, update remote_password_file to EXCLUSIVE before modifying the SYS password.