how to disable and enable triggers for schema user 1

[jasper04]

any one help me with script to disable and enable triggers for schema user. Schema user is Student

Thanks

 

[SantaMufasa]

Here are my triggers and their statuses:

select trigger_name,status from user_triggers;

TRIGGER_NAME                   STATUS
------------------------------ --------
FILIPE_EMAIL_CHECK             ENABLED
INSERT_CH1                     ENABLED
MYEEPULSE_TRIGGER3             ENABLED
MYEEPULSE_TRIGGER4             ENABLED
TREVOR_SEQ_GEN                 ENABLED
TRGTST                         ENABLED
TRG_RO_TEST                    ENABLED
UPDATE_CH1_VIEW                ENABLED

8 rows selected.

To disable a user's triggers:

begin
    for x in (select trigger_name trig from user_triggers order by trig) loop
        execute immediate 'alter trigger '||x.trig||' disable';
    end loop;
end;
/

PL/SQL procedure successfully completed.

Here is the confirmation that the above code disabled my triggers:

select trigger_name,status from user_triggers;

TRIGGER_NAME                   STATUS
------------------------------ --------
FILIPE_EMAIL_CHECK             DISABLED
INSERT_CH1                     DISABLED
MYEEPULSE_TRIGGER3             DISABLED
MYEEPULSE_TRIGGER4             DISABLED
TREVOR_SEQ_GEN                 DISABLED
TRGTST                         DISABLED
TRG_RO_TEST                    DISABLED
UPDATE_CH1_VIEW                DISABLED

8 rows selected.

To enable a user's triggers:

begin
    for x in (select trigger_name trig from user_triggers order by trig) loop
        execute immediate 'alter trigger '||x.trig||' enable';
    end loop;
end;
/

Here is the confirmation that the triggers are re-enabled:

select trigger_name,status from user_triggers;

TRIGGER_NAME                   STATUS
------------------------------ -------
FILIPE_EMAIL_CHECK             ENABLED
INSERT_CH1                     ENABLED
MYEEPULSE_TRIGGER3             ENABLED
MYEEPULSE_TRIGGER4             ENABLED
TREVOR_SEQ_GEN                 ENABLED
TRGTST                         ENABLED
TRG_RO_TEST                    ENABLED
UPDATE_CH1_VIEW                ENABLED

8 rows selected.

Let us know if this does what you requested.

PL/SQL procedure successfully completed.[/code]

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[jasper04]

Thanks Santha for your input you are the mann!!