TMA-ORACLE-DB-2.3.7

Ensure 'REMOTE_OS_ROLES' Is Set To 'FALSE'

ÉlevéeNiveau 1Automatiséeoracle-db

Description

The remote_os_roles setting permits remote users' OS roles to be applied to database management. This setting should have a value of FALSE. Counts non-compliant GV$SYSTEM_PARAMETER rows across instances and containers; 0 is required. Default: FALSE 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.

Méthode de vérification

Méthode d'audit: Requête SQL

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 gv$system_parameter v
where upper(v.name) = 'REMOTE_OS_ROLES'
and upper(v.value) != 'FALSE';
exit
EOF
) || exit 1
printf '%s\n' "$out"

Sortie attendue: 0

Méthode de correction

Méthode de correction: Recommandation ou correctif d'infrastructure

To remediate this setting, execute the following SQL statement and restart the instance. ALTER SYSTEM SET REMOTE_OS_ROLES = FALSE SCOPE = SPFILE; Note: This parameter is not modifiable at the PDB level. You must modify this parameter at the CDB level.

Propriétés

Systèmes d'exploitation: Tous
Étiquettes: oracle-dbdatabaseoracleparameters
Référence: CIS Oracle Database 23ai Benchmark v1.1.0 - 2.3.7 Ensure 'REMOTE_OS_ROLES' Is Set To 'FALSE'

Vérifier cet hôte

Exécutez cette commande sur une machine que vous êtes autorisé à auditer. L'analyse est en lecture seule.

shell

tmaegis scan --target oracle-db