Home » RDBMS Server » Security » Audited objects
Audited objects [message #161566] Mon, 06 March 2006 01:19 Go to next message
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 Go to previous message
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



Previous Topic: user_ts_quotas shows removed tablespace info
Next Topic: audit_sys
Goto Forum:
  


Current Time: Mon Dec 06 19:59:39 CST 2021