TMA-ORACLE-DB-2.2.6

Ensure 'SQLNET.ENCRYPTION_CLIENT Is Set To 'REQUIRED'

VisokaNivo 1Automatskaoracle-db

Opis

The SQLNET.ENCRYPTION_CLIENT parameter determines whether the client side of a database connection enforces network encryption. When set to REQUIRED, this parameter mandates that all data transmitted between the client and the database is encrypted, preventing the client from connecting if encryption cannot be established. This setting ensures that sensitive data remains protected during ... The last uncommented setting in sqlnet.ora must equal REQUIRED (case-insensitive, spaces ignored). Default: ACCEPTED Reads the file from $TNS_ADMIN, or $ORACLE_HOME/network/admin when TNS_ADMIN is unset (Linux/UNIX hosts); fails when neither directory exists.

Kako se proverava

Metod provere: Komanda ljuske

shell

d="${TNS_ADMIN:-${ORACLE_HOME:?ORACLE_HOME not set}/network/admin}"; [ -d "$d" ] || { echo "missing $d"; exit 1; }; f="$d/sqlnet.ora"; [ -f "$f" ] || { echo "noncompliant: $f not found"; exit 0; }; v=$(grep -Ei '^[[:space:]]*SQLNET\.ENCRYPTION_CLIENT[[:space:]]*=' "$f" | tail -n 1 | sed 's/^[^=]*=//' | tr -d ' \t\r' | tr '[:lower:]' '[:upper:]'); [ "$v" = "REQUIRED" ] && echo compliant || echo "noncompliant: ${v:-not set}"

Očekivani izlaz: compliant

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

To remediate this recommendation, set SQLNET.ENCRYPTION_CLIENT to REQUIRED.

Svojstva

Operativni sistemi: Bilo koji
Oznake: oracle-dbdatabaseoraclenetworkencryption
Referenca: CIS Oracle Database 23ai Benchmark v1.1.0 - 2.2.6 Ensure 'SQLNET.ENCRYPTION_CLIENT Is Set To 'REQUIRED'

Proverite ovaj računar

Pokrenite ovo na računaru za koji imate dozvolu za proveru. Skeniranje radi u režimu samo za čitanje.

shell

tmaegis scan --target oracle-db