SV-270524r1112471_rule
V-270524
SRG-APP-000516-DB-000363
O19C-00-009200
CAT II
10
Set the parameter to FALSE for all instances. If using Oracle Multitenant, set the value to FALSE for the container database and all pluggable databases will be set to FALSE as well.
ALTER SYSTEM SET remote_os_roles = FALSE scope=spfile;
sid='container_name' is optional
Restart the database for the change to take effect.
To verify the current status of the remote_os_roles parameter use the SQL statement:
If using a non-CDB database:
From SQL*Plus:
COLUMN name format a20
COLUMN parameter_value format a20
SELECT name, con_id, value AS PARAMETER_VALUE
FROM sys.v_$parameter
WHERE vp.name = 'remote_os_roles'
ORDER BY 1;
If the PARAMETER_VALUE is not FALSE, that is a finding.
If using a CDB database:
From SQL*Plus (in the CDB database):
COLUMN name format a20
COLUMN parameter_value format a20
SELECT name, inst_id, con_id, value AS PARAMETER_VALUE
FROM sys.gv_$parameter
WHERE vp.name = 'remote_os_roles'
ORDER BY 1;
In the CDB database, if the PARAMETER_VALUE is not FALSE, that is a finding.
V-270524
False
O19C-00-009200
To verify the current status of the remote_os_roles parameter use the SQL statement:
If using a non-CDB database:
From SQL*Plus:
COLUMN name format a20
COLUMN parameter_value format a20
SELECT name, con_id, value AS PARAMETER_VALUE
FROM sys.v_$parameter
WHERE vp.name = 'remote_os_roles'
ORDER BY 1;
If the PARAMETER_VALUE is not FALSE, that is a finding.
If using a CDB database:
From SQL*Plus (in the CDB database):
COLUMN name format a20
COLUMN parameter_value format a20
SELECT name, inst_id, con_id, value AS PARAMETER_VALUE
FROM sys.gv_$parameter
WHERE vp.name = 'remote_os_roles'
ORDER BY 1;
In the CDB database, if the PARAMETER_VALUE is not FALSE, that is a finding.
M
5672