The Oracle REMOTE_OS_ROLES parameter must be set to FALSE.
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
| V-219831 | O121-BP-022000 | SV-219831r961863_rule | High |
| Description |
| Setting REMOTE_OS_ROLES to TRUE allows operating system groups to control Oracle roles. The default value of FALSE causes roles to be identified and managed by the database. If REMOTE_OS_ROLES is set to TRUE, a remote user could impersonate another operating system user over a network connection. |
| STIG | Date |
| Oracle Database 12c Security Technical Implementation Guide | 2025-02-12 |
Details
| Check Text (C-21542r903016_chk) |
| From SQL*Plus: select value from v$parameter where name = 'remote_os_roles'; If the value returned is FALSE, this is not a finding. If the value returned is TRUE, confirm that the setting is justified and documented. If not, this is a finding. |
| Fix Text (F-21541r533033_fix) |
| Document remote OS roles in the System Security Plan. If not required, disable use of remote OS roles. From SQL*Plus: alter system set remote_os_roles = FALSE scope = spfile; The above SQL*Plus command will set the parameter to take effect at next system startup. |