Reports : PCI, SOX, and HIPAA reports : Report: Abnormal Termination of Database Activity
 
Report: Abnormal Termination of Database Activity
This report identifies failed database processes (that is, financial transactions) originating from the application server. This report should be reviewed on a daily basis by IT Management.
COBIT objectives
This report is designed to meet the following COBIT objectives:
Objective Number
Description
DS10.1
Routine transactions and processes between the application and the database are reviewed on a daily basis for successful completion by IT Management.
Setup requirements
Sox Abnormal Termination of Database Activity policy: Object Audit Options and/or User Audit Options
Report columns
The following columns are displayed in the report body.
Columns
Description
User ID
The ID of the database user that conducted the flagged activity
Object
The name and owner of the database object that was directly manipulated by the flagged activity
Timestamp
The exact time the flagged activity was conducted
Terminal
The terminal IP address or name
Origin Application
The name, or other identifier, for the originating application, if the activity originated from an external application or from an application server
Action Type
The type of action successfully enacted by the User ID.
Error Code
The proprietary error code generated by the originating application.
See also
General steps for generating PCI, SOX, and HIPAA reports