Hitachi

Hitachi Advanced Database Setup and Operation Guide


2.18.4 Information output in an audit trail

An audit trail records information such as who performed an operation, when the operation was performed, and the nature of the operation. The following shows an example of the information output in an audit trail:

Example 1:
SELECT * FROM "T1" WHERE "C1"=100

When the preceding SQL statement is executed, audit trail information is output as follows:

[Figure]

Example 2:

The following shows the information output as an audit trail if the adbimport command were executed:

[Figure]

These examples show just some of the information output in audit trails. For more details about the information output in audit trails, see 12.9.2 Column structure of table function derived table when retrieving audit trails and 12.9.3 Audit trail output triggers and output items.