Home » SQL & PL/SQL » SQL & PL/SQL » Needed help for Auditing (Windows 2000)
Needed help for Auditing [message #321216] Mon, 19 May 2008 08:09 Go to next message
Messages: 2
Registered: April 2008
Location: Pune
Junior Member
Hi Friends,
I need to audit the particular schemas object , however through oracle
i m just getting the command fired by the user n all other
details which r present in dba_audit_trail , however for example
if user changes sal from 100 to 200 then i should get these two values.

My need to audit schema and if that user inserts, updates or deletes any thing then
it should be recoded into one table along with old abd new values.

please suggest me something.

I badly need this solution.

Re: Needed help for Auditing [message #321217 is a reply to message #321216] Mon, 19 May 2008 08:12 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ read OraFAQ Forum Guide and don't use IM/SMS speak.

2/ Have a look at fine-grained auditing

Previous Topic: Query need
Next Topic: How to Create user defined data types?
Goto Forum:

Current Time: Sun Oct 23 05:06:06 CDT 2016

Total time taken to generate the page: 0.18380 seconds