TMA-DB2-ZOS-3.1.5
Enable auditing of system administrator access
Description
System administrator authorities perform system administrator tasks and include administrative authorities such as SYSADM, SYSCTRL, and SYSOPR. The SYSADM authority has access to all data. Auditing tasks that are performed by system administrators can help detect unauthorized or malicious activities intended to do harm to Db2 data or the processing environment.
How it is checked
Audit method: Manual review
This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.
For Db2 internal security users: Issue the following SQL statement to verify that the audit policy is enabled to audit SYSADM, SYSCTRL, SYSOPR or all authorities in SYSADMIN category: SELECT AUDITPOLICYNAME FROM SYSIBM.SYSAUDITPOLICIES WHERE SYSADMIN IN ('L','O','S','*'); For external security users: Ensure that SMF 80 trace is ON and the Db2 administrator profiles in RACF have AUDIT(ALL) specified.
How it is fixed
Fix method: Guidance or infrastructure patch
For Db2 internal security users: Enable AUDITPOLICIES with the SYSADMIN category to audit SYSADM, SYSCTRL, and SYSOPR authorities. For external security users: Specify AUDIT(ALL) for the Db2 administrator profiles in RACF and start SMF 80 trace.
Properties
- Operating systems
- Any
- Tags
- db2-zosaudit
- Reference
- CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 3.1.5 Enable auditing of system administrator access