Home » RDBMS Server » Security » Audit inside trigger activity (LInux, 10.2.0.2)
Audit inside trigger activity [message #349356] Sat, 20 September 2008 12:54 Go to next message
Bangla
Messages: 49
Registered: August 2008
Member
I want to audit the SQL statements inside trigger. Like whenever the sql statements inside trigger is executed successfully or not successful an audit event will be generated in the DBA_AUDIT_TRAIL.
How can I achive my goal.
Re: Audit inside trigger activity [message #349364 is a reply to message #349356] Sat, 20 September 2008 13:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For Oracle there is no difference between a SQL executed inside a trigger or not.
Add logging inside your trigger and log into your own log table.

Regards
Michel
Re: Audit inside trigger activity [message #349365 is a reply to message #349356] Sat, 20 September 2008 13:36 Go to previous message
Bangla
Messages: 49
Registered: August 2008
Member
thank you much
Previous Topic: Password Exp Warning
Next Topic: Possible to findout the module from Updating?
Goto Forum:
  


Current Time: Mon Dec 05 14:52:24 CST 2016

Total time taken to generate the page: 0.09742 seconds