12.4.3 Checking audit target definitions

To check audit target definitions, you retrieve data from the SQL_AUDITS dictionary table.

Important

Only an HADB user with the audit admin privilege can retrieve data from the SQL_AUDITS dictionary table.

The following shows an example of retrieving data from the SQL_AUDITS dictionary table:

Example of SQL statement execution

SELECT * FROM "MASTER"."SQL_AUDITS"

Example search results

OPERATION_TYPE   EVENT_TYPE  ...  AUDIT_TYPE  IS_EXCLUSION_AUDIT
--------------   ----------       ----------  ------------------
ANY              **********  ...  EVENT                        N

A row of search results means that an audit target definition has been defined. In this example, the presence of this definition means that audit trails will also be output for optional audit events.

A lack of search results indicates that there is no audit target definition. In this case, audit trails will not be output for optional audit events.

Note that the search results in this example are those output if the SQL statement was executed by the adbsql command. ********** represents a null value.

To Page Top