TMA-ORACLE-DB-4.1

Ensure All Default Passwords Are Changed

KritikDüzey 1Otomatikoracle-db

Açıklama

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. Counts every account listed in CDB_USERS_WITH_DEFPWD, locked or not, as the benchmark does. Run on the database host as the Oracle software owner with ORACLE_HOME, ORACLE_SID and PATH set; connects to the CDB root with 'sqlplus -S / as sysdba' (OS authentication) so CDB_/GV$ views cover all open PDBs.

Nasıl denetlenir

Denetim yöntemi: SQL sorgusu

sql_query

out=$(sqlplus -S -L / as sysdba 2>/dev/null <<'EOF'
whenever sqlerror exit failure
set heading off feedback off pagesize 0 verify off echo off trimspool on define off
select count(*) from cdb_users_with_defpwd a, cdb_users c
where a.username = c.username and a.con_id = c.con_id;
exit
EOF
) || exit 1
printf '%s\n' "$out"

Beklenen çıktı: 0

Nasıl düzeltilir

Düzeltme yöntemi: Kılavuz veya altyapı yaması

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 USER 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.

Özellikler

İşletim sistemleri: Herhangi biri
Etiketler: oracle-dbdatabaseoracleauthentication
Referans: CIS Oracle Database 23ai Benchmark v1.1.0 - 4.1 Ensure All Default Passwords Are Changed

Bu ana makineyi denetle

Bunu denetleme izniniz olan bir makinede çalıştırın. Tarama salt okunurdur.

shell

tmaegis scan --target oracle-db