4.3 Review The Users Created Through Real Application Security

Information

Oracle Real Application Security (RAS) introduces an alternative user model that allows users to log in directly (e.g., with SQL*Plus) when DIRECT_LOGON = YES RAS users do not appear in the D BA_USERS or CDB_USERS views and are not created using the standard CREATE USER command, making them difficult to detect. To ensure proper security monitoring, the CDB_XS_USERS view should be reviewed regularly.

RAS users are not visible in traditional DBA_USERS or CDB_USERS views. Privileges for RAS users are stored and displayed separately from standard database users. Without regular monitoring, unauthorized or unintended RAS users may remain undetected. Security assessments must include RAS-related views, such as CDB_XS_USERS and DBA_XS_USERS to analyze users and their authorizations.

NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.

Solution

Remove RAS-Users that are not needed.

BEGIN
SYS.XS_PRINCIPAL.DELETE_PRINCIPAL('<rasuser>');
END;

Impact:

Dropping a RAS user may result in data loss or impact application availability, requiring thorough assessment before taking action. Some applications or scripts may rely on RAS users for specific tasks. Removing it may break these applications, requiring modifications or redesign.

See Also

https://workbench.cisecurity.org/benchmarks/16474

Item Details

Category: ACCESS CONTROL

References: 800-53|AC-2, CSCv7|16.6

Plugin: OracleDB

Control ID: f600522104fcc31a2c8408ebd22e48f6b087c9c4edf4f33e4fecaaed8d7c0f7a