4.1 Ensure All Default Passwords Are Changed

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.

See Also

https://workbench.cisecurity.org/benchmarks/16474

Item Details

Category: IDENTIFICATION AND AUTHENTICATION

References: 800-53|IA-5, CSCv7|4.2

Plugin: OracleDB

Control ID: 26f6dbbf8fd8268631d9ebed1e605ecd36006e358025859debbf90752c4a97c0