| Audited objects [message #161566] |
Mon, 06 March 2006 01:19  |
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
|
Member |
|
|
hi All.
Does anyone have a script that can give me everything that is being Audited(like which table is audited for what) on the DB and what its audited for after the audit trail is set for the DB
|
|
|
|
| Re: Audited objects [message #161624 is a reply to message #161566] |
Mon, 06 March 2006 06:38  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
i dont have the script, but if you can check some of the views listd at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/audit.htm#10459
perhaps, you can get required info. see a part of this link:
DBA_OBJ_AUDIT_OPTS
USER_OBJ_AUDIT_OPTS
Describes auditing options on all objects. USER view describes auditing options on all objects owned by the current user.
DBA_AUDIT_TRAIL
USER_AUDIT_TRAIL
Lists all audit trail entries. USER view shows audit trail entries relating to current user.
DBA_AUDIT_OBJECT
USER_AUDIT_OBJECT
Contains audit trail records for all objects in the system. USER view lists audit trail records for statements concerning objects that are accessible to the current user.
DBA_AUDIT_SESSION
USER_AUDIT_SESSION
Lists all audit trail records concerning CONNECT and DISCONNECT. USER view lists all audit trail records concerning connections and disconnections for the current user.
DBA_AUDIT_STATEMENT
USER_AUDIT_STATEMENT
Lists audit trail records concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements throughout the database, or for the USER view, issued by the user
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
