Re: Debug DDL trigger

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 24 Aug 2005 00:07:02 -0700
Message-ID: <bf463805082400071e143c86@mail.gmail.com>

On 8/23/05, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> Looks to me like it's firing:
>
>

Hi Wolfgang,

Yes, you are correct of course.

I misrembered some testing I had done with these a couple months ago.

Logon triggers do indeed fire if you have the DBA role, or more specifically the ADMINSTER DATABASE TRIGGER privilege.

The difference is that users with this privilege cannot be prevented from logging into the database by raising and error in the trigger. All other users may be prevented from logging on.

See MetaLink note 265012.1

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 24 2005 - 02:14:13 CDT