Disable triggers

  • From: Joe Smith <joe_dba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Jun 2010 11:28:40 -0500

How to disable triggers on a table?
 
I have multiple schemas and I want to create a procedure ( that when executed 
will disable/enable triggers )  that will be owned by one schema that can 
disable triggers on all the schemas.   I want to do this without granting ALTER 
ANY TRIGGER.  Is this possible?
                                          
_________________________________________________________________
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1

Other related posts: