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: 68625
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: Thu Mar 28 13:45:53 CDT 2024