Home » RDBMS Server » Security » audit of DML
audit of DML [message #63286] Fri, 24 September 2004 02:22 Go to next message
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 Go to previous message
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
Previous Topic: Password Encryption Prb
Next Topic: How to obtain forgotten passwords
Goto Forum:
  


Current Time: Tue Nov 30 11:50:09 CST 2021