Home » RDBMS Server » Security » auditing problem
auditing problem [message #282733] Fri, 23 November 2007 03:58 Go to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
i am trying to audit the database, in the sense, our
application is built in java and oracle, so whatever action
occurs in the front end, i want to audit and see which
packages are called from the database side, which we can view
in event viewer in case of xp..

so i simply logged into my system user and gave this command

audit insert table,execute procedure by wcmcpp2;



but i am not able to audit, is there anything extra i need to do?
Re: auditing problem [message #282739 is a reply to message #282733] Fri, 23 November 2007 04:37 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
soujanya_srk wrote on Fri, 23 November 2007 10:58

but i am not able to audit, is there anything extra i need to do?
That's rather vague, don't you agree? Do you get an error? Doesn't the audit work?

MHE
Re: auditing problem [message #282745 is a reply to message #282733] Fri, 23 November 2007 04:51 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
audit_trail parameter must FIRST be set to DB (or other value but FALSE).

Regards
Michel
Previous Topic: ORA-01031--- insufficient privileges
Next Topic: A question about ALTER User statement
Goto Forum:
  


Current Time: Thu Mar 28 20:05:51 CDT 2024