Analysis/Reporting of sys.aud$ table [message #62943] |
Wed, 25 August 2004 08:00 |
Leslie Tsukamoto
Messages: 1 Registered: August 2004
|
Junior Member |
|
|
I have initiated Auditing on several objects and users and can see the audit log entries accumulating in the sys.aud$ table. However, I am not 100% sure as to what each column in the sys.aud$ represents and need to get a better handle of how to decipher the data that is being logged. I would like to have some documentation as to what each column is tracking - does anyone have any idea where I can get this information from?
|
|
|
Re: Analysis/Reporting of sys.aud$ table [message #62991 is a reply to message #62943] |
Tue, 31 August 2004 03:37 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
SYS.AUD$ is not documented in the Server Reference Guide. It's better to use the documented views created on SYS.AUD$ - like DBA_AUDIT_TRAIL, DBA_AUDIT_OBJECT, DBA_AUDIT_SESSION, DBA_AUDIT_STATEMENT, DBA_AUDIT_EXIST, etc.
Best regards.
Frank
|
|
|