| audit of DML [message #63286] |
Fri, 24 September 2004 02:22  |
Jay
Messages: 127
Registered: October 1999
|
Senior Member |
|
|
Hi All,
What I require is that to capture all delete statements that have been done from the sql prompt manually and not from the application.
Its something like the query below. But at the same time I require the DML statement of the delete command. can you please give some idea how to go about.
select A.USERNAME, B.USERNAME,A.ACTION_NAME,A.OBJ_NAME,A.TIMESTAMP,A.TERMINAL,B.PROGRAM from dba_audit_trail A, V$SESSION B
WHERE A.USERNAME=B.USERNAME AND A.ACTION_NAME='SELECT'
TIA
Jay
|
|
|
|
| Re: audit of DML [message #63288 is a reply to message #63286] |
Fri, 24 September 2004 03:07  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
to make audit feature enable then first you have make some changes in init parameter file
do the following
1)shutdown the database(if it is not your production database running for 24/7 otherwise skip this operation and do it when ur database will have idle time.
2)open a init parameter file of your database instance then make the below change for the following parameter
audit_trail = true or db
save the changes and quit
3)restart the database
4)now depanding upon ur auditing options u can do following things with syntax at sql prompt
audit <dml> by access whenever successful;
once you do this all the info will be stored in data dictionary views.
This will work
D.Dilip
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
