Debug DDL trigger 2005-08-24 - By Jared Still
Yes, it is true, at least in the context I meant it in.
I should have been more specific.
Try using raise_application_error, or any other error to
prevent an account from logging in.
If a user has the ADMINISTER DATABASE TRIGGER privilege, you cannot
use a trigger to prevent him from logging in.
You might take a look a look at the MetaLink note referenced earlier.
Jared
On 8/24/05, rjamya <rjamya@(protected)> wrote:
>
> Not true, see below for an example on 9204
>
> SQL> get t1.sql
> 1 conn t1/t1
> 2 create table t1.some_tbl tablespace cons
> 3 as select * from dba_objects where rownum < 100
>
...
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Yes, it is true, at least in the context I meant it in.<br>
<br>
I should have been more specific.<br>
<br>
Try using raise_application_error, or any other error to <br>
prevent an account from logging in.<br>
<br>
If a user has the ADMINISTER DATABASE TRIGGER privilege, you cannot<br>
use a trigger to prevent him from logging in.<br>
<br>
You might take a look a look at the MetaLink note referenced earlier.<br>
<br>
Jared<br>
<br><div><span class="gmail_quote">On 8/24/05, <b class="gmail_sendername"
>rjamya</b> <<a href="mailto:rjamya@(protected)">rjamya@(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;">
Not true, see below for an example on 9204<br>
<br>
SQL> get t1.sql<br>
1 conn t1/t1<br>
2 create table t1.some_tbl tablespace cons<br>
3 as select * from dba_objects where rownum < 100<br><
/blockquote></div>...<br>
<br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist
<br><br>
|
|
