Re: after logon trigger

Thanks,

I found the answer, the user has ADMINISTER DATABASE TRIGGER -privilege.

Best Regards,

Maija-Leena

"Maxim Demenko" <mdemenko_at_arcor.de> wrote in message news:47CCF54F.3030405_at_arcor.de...
> Maija-Leena schrieb:
> > 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
> >
> >
>
> You can look up the Metalink Note 265012.1
>
> Best regards
>
> Maxim
Received on Tue Mar 04 2008 - 02:22:38 CST