Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Debug DDL trigger

Re: Debug DDL trigger

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 23 Aug 2005 23:07:55 -0700
Message-ID: <bf463805082323073b1b11c4@mail.gmail.com>


I believe the triggers that Raj was thinking of were logon triggers.

Those do not fire for accounts with the DBA privilege.

Jared

On 8/23/05, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> At 08:08 AM 8/23/2005, rjamya wrote:
> >psst: for all this to succeed, you should be a non-dba user ...
> >these triggers don't fire for people with DBA privs.
>
> Not quite correct. They don't fire for sys, but they DO fire for
> ordinary users, even those with the DBA role.
>
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> http://www.centrexcc.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 24 2005 - 01:09:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US