| Audit Information [message #142487] |
Fri, 14 October 2005 16:46  |
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
|
Member |
|
|
Hi,
I have a Production Database...Generally when i create users in it ,i enable the audit trail for these users..Now my question is which tables enable me to track their activity..If it is sys.AUD$ then how to i (Which columns do i use to find out activity by that user ,illegal or legal)track the statements they have executed in the database...
Thanks
Manju
|
|
|
|
| Re: Audit Information [message #142635 is a reply to message #142487] |
Mon, 17 October 2005 00:42  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Whatever audit is started its entry comes into DBA_AUDIT_TRIAL & if you are auditing session wise then dba_audit_session..
below are View & Description
STMT_AUDIT_OPTION_MAP
Contains information about auditing option type codes. Created by the SQL.BSQ script at CREATE DATABASE time.
AUDIT_ACTIONS
Contains descriptions for audit trail action type codes
ALL_DEF_AUDIT_OPTS
Contains default object-auditing options that will be applied when objects are created
DBA_STMT_AUDIT_OPTS
Describes current system auditing options across the system and by user
DBA_PRIV_AUDIT_OPTS
Describes current system privileges being audited across the system and by user
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
DBA_AUDIT_EXISTS
Lists audit trail entries produced BY AUDIT NOT EXISTS
DBA_AUDIT_POLICIES
Shows all the auditing policies on the system.
DBA_FGA_AUDIT_TRAIL
Lists audit trail records for value-based auditing.
DBA_COMMON_AUDIT_TRAIL
Combines standard and fine-grained audit log records
Regards
Always Friend Sunilkumar
[Updated on: Mon, 17 October 2005 01:05] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
