Database System Modifications Report

To search for and generate a report on system database changes such as drops and table drops, use the Database System Modifications Real-Time Report.

Menu path: Reports > Database Activity > Database System Modifications

In addition to setting the common report options in Preparing a Real-time Report, you can select optional filter operators in the generated report.

Optional filter operators can be sorted in ascending or descending order. Choose sort order using the drop-down menu. By default, the following options are selected: Source Device, Database, DB User, Database Object Name, Access/Modification Type, and Count.

For information on saving the generated report, see Formats for Saving a Generated Report.

Database System Modifications Report - Optional Filter Operators
Option Description
Source Device Description of the device that sent log data
Database Database name on which the action occurred
DB User User name of the database user whose actions were audited
Sys Priv System privileges granted or revoked
Database Object Name Name of the object affected by the action
Status Status or return code of the action completion (numeric value)
Severity Severity level of the event
OS User Operating system login user name of the user whose actions were audited
Event Type ID Database vendor audit code for the action type
Access/Modification Type Modification action of a user, profile, or role privilege
Object Priv Object privileges granted or revoked on the database object
Count Number of log entries returned with the given parameters