after logon trigger
From: Maija-Leena <kangasmaki_at_netti.fi>
Date: Tue, 04 Mar 2008 06:25:49 GMT
Message-ID: <NX5zj.7$VM3.6@read4.inet.fi>
Date: Tue, 04 Mar 2008 06:25:49 GMT
Message-ID: <NX5zj.7$VM3.6@read4.inet.fi>
Hi,
if an after logon trigger is invalid, will dba-users be able to connect ?
We are going to use after logon trigger which executes a procedure. When I make an error to the procedure the trigger will be invalidated. I thought that no one would be able to connect, but my dba-user still can, so I don't need to set parameter _system_trig_enabled to false. This works different than I thought. Is there a document that explains, when the trigger is not fired or am I doing something wrong while testing it ?
Regards, Maija-Leena Received on Tue Mar 04 2008 - 00:25:49 CST