DO0240-ORACLE11 - The Oracle OS_ROLES parameter should be set to FALSE - 'os_roles = false'

Information

The OS_ROLES parameter specifies whether Oracle roles are defined and managed by the DBMS or by the host operating system. To maintain and support the separation of duties between host system administration and DBMS administration, the DBMS must be configured to use only roles defined and managed by the DBA. Separation of duties supports assignment of privileges by job function and supports accountability.

Solution

From SQL*Plus:

alter system set os_roles = FALSE scope = spfile;

The above SQL*Plus command will set the parameter to take effect at next system startup.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_Oracle_Database_11g_Y21M10_STIG.zip

Item Details

Category: ACCESS CONTROL

References: 800-53|AC-2(7), 800-53|AC-17, CAT|III, Rule-ID|SV-24881r2_rule, STIG-ID|DO0240-ORACLE11, Vuln-ID|V-2519

Plugin: OracleDB

Control ID: f71b409a5e2d8602d0ca4750a579f931ff472dc35f668bd7a55788b35e4197f1