Re: Debug DDL trigger

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: breitliw@xxxxxxxxxxxxx
  • Date: Tue, 23 Aug 2005 23:07:55 -0700

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@xxxxxxxxxxxxx> 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
> 
> --
> //www.freelists.org/webpage/oracle-l
> 



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

Other related posts: