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
mohdmujtaba
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.

Thanx.
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: 64152
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

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


Current Time: Sat Dec 10 09:11:27 CST 2016

Total time taken to generate the page: 0.10845 seconds