Re: Debug DDL trigger

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: Dave.Herring@xxxxxxxxxx
  • Date: Tue, 23 Aug 2005 10:08:15 -0400

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@xxxxxxxxxx> 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.
> 
>

Other related posts: