What is your opinion on using custom triggers to audit tables [message #173742] |
Wed, 24 May 2006 05:19 |
manwadkar
Messages: 104 Registered: September 2005 Location: Washington DC
|
Senior Member |
|
|
I want to audit transactions like Invoices, POs, vendors etc.. using custom database oracle triggers. What do you think on this? I know triggers affect performance of system. But I see there is no option? Do you know any other option?
|
|
|
|
|
|
|
Re: What is your opinion on using custom triggers to audit tables [message #174167 is a reply to message #174146] |
Fri, 26 May 2006 05:38 |
adragnes
Messages: 241 Registered: February 2005 Location: Oslo, Norway
|
Senior Member |
|
|
I hope you are not basing decisions which has consequences such as loosing support on your feelings alone. How come you feel that you can design a custom solution that is significantly less of a burden than the standard out-of-the-box solution from Oracle? Have benchmarked you solution against the standard?
If you insist on building your own solution, I would urge you to take a look at the Oracle Database Security Guide. It contains a lot of information about the auditing functionality in the database.
--
Aleksander Dragnes
|
|
|