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@(protected)> 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. > >
psst: for all this to succeed, you should be a non-dba user ... these triggers don't fire for people with DBA privs.<br> <br> Raj<br><br><div><span class="gmail_quote">On 8/23/05, <b class="gmail _sendername">Herring Dave - dherri</b> <<a href="mailto:Dave.Herring@(protected) .com">Dave.Herring@(protected)</a>> wrote:</span><blockquote class="gmail _quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0 .8ex; padding-left: 1ex;"> Another test I did was remove the WHEN clause and not add further WHERE<br>or IF-TEST clauses. Basically, any time a DROP of anything is done when <br>the schema is "dherri", the trigger should fire. That didn't happen <br>either.<br><br></blockquote></div><br>
