Debug DDL trigger 2005-08-24 - By Jared Still
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@(protected)> 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
I believe the triggers that Raj was thinking of were logon triggers.<br>
<br>
Those do not fire for accounts with the DBA privilege.<br>
<br>
Jared<br><br><div><span class="gmail_quote">On 8/23/05, <b class="gmail
_sendername">Wolfgang Breitling</b> <<a href="mailto:breitliw@(protected)"
>breitliw@(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;">
At 08:08 AM 8/23/2005, rjamya wrote:<br>>psst: for all this to succeed, you
should be a non-dba user ...<br>>these triggers don't fire for people with
DBA privs.<br><br>Not quite correct. They don't fire for sys, but they DO fire
for
<br>ordinary users, even those with the DBA role.<br><br><br>Regards<br><br
>Wolfgang Breitling<br>Centrex Consulting Corporation<br><a href="http://www
.centrexcc.com">http://www.centrexcc.com</a><br><br>--<br><a href="http://www
.freelists.org/webpage/oracle-l">
http://www.freelists.org/webpage/oracle-l</a><br></blockquote></div><br><br
clear="all"><br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl
Evangelist<br><br>
|
|
