OraFAQ Forum: Security » Audit inside trigger activity

Home » RDBMS Server » Security » Audit inside trigger activity (LInux, 10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Audit inside trigger activity [message #349356]

Sat, 20 September 2008 12:54

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.

Report message to a moderator

Re: Audit inside trigger activity [message #349364 is a reply to message #349356]

Sat, 20 September 2008 13:29

Michel Cadot
Messages: 68499
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

Report message to a moderator

Re: Audit inside trigger activity [message #349365 is a reply to message #349356]

Sat, 20 September 2008 13:36

Bangla
Messages: 49
Registered: August 2008

Member

thank you much

Report message to a moderator

Previous Topic:	Password Exp Warning
Next Topic:	Possible to findout the module from Updating?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 21 11:16:00 CDT 2023