Oracle Database Security Assessment Report - Operating System

The Oracle Database Security Assessment Report - Operating System section displays the following information:

NameFinding IDDescriptionLink(s)
Installation AccountOS.INSTALLATIONUSERThis check specifies the Oracle installation owner.-
OS AuthenticationOS.AUTH

Displays information about operating system group names and users that can exercise administrative privileges.

OS authentication allows operating system users within the specified user group to connect to the database with administrative privileges. This shows the OS group names and users that can exercise each administrative privilege. OS users with administrative privileges should be reviewed to prevent any unauthorized, malicious or unintentional access to the database.

-
Segregation of Production and Development DatabasesOS.MULTIDBChecks for databases/instances running on the same server. If there are multiple databases/instances running on the same server ensure that it is not hosting production and test/development databases.
Process Monitor ProcessesOS.PMON

Displays whether Process Monitor (PMON) processes are running under the ORACLE_HOME owner account.

The PMON process monitors user processes and frees resources when they terminate. This process should run with the user ID of the ORACLE_HOME owner.

-
Agent ProcessesOS.AGENT

Displays whether Agent processes owners overlap with Listener or Process Monitor (PMON) process owners.

Agent processes should run with a user ID separate from the database and listener processes. These processes should run under a user ID separate from the database and listener processes.

-
Listener ProcessesOS.LISTENER

Displays whether Listener process owners overlap with Agent or Process Monitor (PMON) process owners.

Listener processes accept incoming network connections and connect them to the appropriate database server process. These processes should run with a user ID separate from the database and agent processes. These processes should be administered only through local OS authentication.

Listener PortsOS.LISTENERPORTSDisplays listener ports.-
CMAN Remote AdminOS.CMANLOCALChecks if Oracle Connection Manager is installed in the server and if yes, if CMAN remote administration is configured.
Diagnostic DestinationOS.DIAGNOSTICDEST

Checks value and permissions of DIAGNOSTIC_DEST.

Checks that DIAGNOSTIC_DEST is set to either ORACLE_HOME/rdbms/log or ORACLE_BASE and has file permissions of 700 or lower.

File Permissions in ORACLE_HOMEOS.FILEPERMISSIONS

Displays information about file permissions errors in the ORACLE_HOME.

The ORACLE_HOME directory and its subdirectories contain files that are critical to the correct operation of the database, including executable programs, libraries, data files, and configuration files. Operating system file permissions must not allow these files to be modified by users other than the ORACLE_HOME owner and must not allow other users to directly read the contents of Oracle data files.

-

Note:

On Windows, the DBSAT Collector collects data only from SQL queries. Since the data from the operating system commands is missing, the DBSAT Reporter runs a subset of rules on this data. Operating System findings are not available for databases running on Windows platform.

The following figure displays an example of the Oracle Database Security Assessment Report - Operating System section:

Figure 1 shows the Oracle Database Security Assessment Report - Operating System

Description of the illustration Oracle Database Security Assessment Report - Operating System