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. |