Hitachi

Hitachi Advanced Database Setup and Operation Guide


12.8.5 Performing auditing

After JP1/Audit has collected audit trails, you can search and aggregate them by using the audit log management window of JP1/Audit from a web browser.

Note that the information that the adbconvertaudittrailfile command outputs to common format audit trail files is only the audit trail information that can be displayed with JP1/Audit. The information that can be displayed with JP1/Audit is sometimes insufficient for auditing. For example, JP1/Audit cannot be used to check the SQL statements that were executed and the number of times a table was accessed.

You can also view more details about the audit trail information that can be displayed with JP1/Audit. To do so, execute an SQL statement with the ADB_AUDITREAD function specified for the audit trail files whose names are recorded as specific information of JP1/Audit, and then view the resulting audit trail information. For details about an SQL statement with the ADB_AUDITREAD function specified, see 12.3.3 Referencing audit trails (when using SELECT statements to reference audit trails).