Administering Data › Audit Log › Audit Log

Audit Log

You can use Oracle or SQL database tools to open the HARAUDITLOGVIEW view and examine the audit log. For example, open the contents of HARAUDITLOGVIEW in Oracle Enterprise Manager to view all the records that are currently in the audit log.

Each audit log record in HARAUDITLOGVIEW contains the following:

• The time and sequence identifier for the audit event
• The identifier and name of the action associated with the audit event
• The success or failure of the action attempted
• The identifier and name of the user associated with the action
• The process identifier and node name associated with the client and server process associated with the action
• The name and identifier associated with the resource of the audit action, and all ancestor resources of this resource
• The resource type name and resource type identifier associated with the resource, and all ancestor resources of this resource

Alternatively, you can use the Structured Query Language (SQL) standard query format to query the HARAUDITLOGVIEW database view and report audit events which have been logged. Queries retrieve information from a database and consist of questions presented to the database in a predefined format.

Important! The use of object IDs instead of object names results in faster execution of queries.

More information:

HARAUDITLOGVIEW