Debug DDL trigger 2005-08-24 - By Jared Still
On 8/23/05, Wolfgang Breitling <breitliw@(protected)> wrote:
>
> Looks to me like it's firing:
>
>
Hi Wolfgang,
Yes, you are correct of course.
I misrembered some testing I had done with these a couple months ago.
Logon triggers do indeed fire if you have the DBA role, or more specifically
the ADMINSTER DATABASE TRIGGER privilege.
The difference is that users with this privilege cannot be prevented from
logging into the database by raising and error in the trigger. All other
users may be prevented from logging on.
See MetaLink note 265012.1
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
<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;">
Looks to me like it's firing:<br><br></blockquote></div><br>
Hi Wolfgang,<br>
<br>
Yes, you are correct of course.<br>
<br>
I misrembered some testing I had done with these a couple months ago.<br>
<br>
Logon triggers do indeed fire if you have the DBA role, or more specifically<br>
the ADMINSTER DATABASE TRIGGER privilege.<br>
<br>
The difference is that users with this privilege cannot be prevented from <br>
logging into the database by raising and error in the trigger. All other
<br>
users may be prevented from logging on.<br>
<br>
See MetaLink note <font face="helvetica">265012.1</font><br>
<br>
-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist<br>
<br>
|
|
