5.2 Ensure the 'LOGON' AND 'LOGOFF' Actions Audit Is Enabled

Information

Oracle database users log on to the database to perform their work. Enabling this unified audit causes logging of all LOGON actions, whether successful or unsuccessful, issued by the users regardless of the privileges held by the users to log into the database. In addition, LOGOFF and LOGOFF BY CLEANUP action audit captures logoff activities. This audit action also captures logon/logoff to the open database by SYSDBA and SYSOPER

Logging and monitoring of all attempts to logon to the database, whether successful or unsuccessful, may provide forensic evidence about potential suspicious/unauthorized activities. Any such activities may be a cause for further investigation. In addition, organization security policies and industry/government regulations may require logging of all user activities involving LOGON LOGOFF and LOGOFF BY CLEANUP

Solution

Execute the following SQL statement to remediate this setting.

Run the following query in the CDB and in each PDB:

CREATE AUDIT POLICY CIS_CDB_LOGON_LOGOFF
ACTIONS
LOGON, LOGOFF
ACTIONS
COMPONENT=PROTOCOL HTTP, FTP, AUTHENTICATION;

AUDIT POLICY CIS_CDB_LOGON_LOGOFF;

Note: If you do not have CIS_CDB_LOGON_LOGOFF please create one using the CREATE AUDIT POLICY statement. Refer to Section 8.2 where a PL/SQL block is provided to help create or modify the audit policy to remediate this item in both container and pluggable database.

See Also

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