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: rjamya <rjamya_at_gmail.com>
Date: Tue, 23 Aug 2005 10:08:15 -0400
Message-ID: <9177895d05082307084c42a19@mail.gmail.com>


psst: for all this to succeed, you should be a non-dba user ... these triggers don't fire for people with DBA privs.

Raj

On 8/23/05, Herring Dave - dherri <Dave.Herring_at_acxiom.com> wrote:
>
> Another test I did was remove the WHEN clause and not add further WHERE
> or IF-TEST clauses. Basically, any time a DROP of anything is done when
> the schema is "dherri", the trigger should fire. That didn't happen
> either.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 23 2005 - 09:10:13 CDT

Original text of this message

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