Franklin,
In SQL Server, I believe trigger information is stored in the sys_
tables inside the database. Don't know about Oracle, but I would
expect something similar.
However, given that the client is maliciously disabling your
triggers, I wouldn't actually worry about it. If I buy a car, then
remove the engine, it's not the automakers fault.
Just my 2 cents.
Regards,
Bryan Porter
On Sep 12, 2006, at 2:58 PM, Franklin Gray wrote:
I would like to enable all triggers in our DB that runs on a oracle
client
machine from VB.net. Anybody know how to do this without knowing
which
triggers are already there? We could run SQL scripts to enable
them but
then when we add new triggers I have a feeling they would be
forgotten in
this utility and then the finger pointing would start. I want to
enumerate through the existing triggers and enable them if they aren't
enabled. Our client has a habbit of disabling our triggers.
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://
discuss.develop.com
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
