Christian wrote:

>>Really???????? You want the ability for any user to deactivate
>>triggers? A user working with triggers deactivated would require
>>exclusive
>>access to the system. Getting exclusive access requires the SYSDBA to do
>>the shutdown anyway, so SYSDBA can deactivate the trigger and then
>>reactivate it before s/he puts the database back online.
>>
>>
>
>
>Maybe i have to search for an other way (but wouldn´t be so convenient) :-)
>
>thanks,
> chris
>
>

Chris,

Could you put some flag column in you table and check this flag in your
trigger with an "if" and do or not the trigger code ?

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br