Re: PUP table

From: Tim Gorman <tim_at_sagelogix.com>
Date: Thu, 12 Aug 2004 21:48:49 -0600
Message-ID: <BD419641.1A2D4%tim@sagelogix.com>

Unfortunately (or rather, fortunately), a failure in an AFTER LOGON trigger does not do anything to interfere with the session...

   SQL> connect scott/tiger
   Connected.
   SQL> create or replace trigger x

     2          after logon
     3          on schema
     4  begin
     5          raise_application_error(-20000, 'raise error');
     6  end x;
     7  /

Trigger created.

   SQL> connect scott/tiger
   Connected.
   SQL> However, in the "alert.log", it says:

Thu Aug 12 21:43:03 2004
Errors in file /Users/oracle/base/admin/TST1/udump/tst1_ora_8963.trc:

   ORA-00604: error occurred at recursive SQL level 1
   ORA-20000: AFTER LOGIN trigger exception
   ORA-06512: at line 2

And the trace file isn't much more helpful than that...

on 8/12/04 3:02 PM, Gogala, Mladen at Mladen.Gogala_at_aetn.com wrote:

> Well, you can also create a login trigger which will look into
> the "module" column of V$SESSION and raise an exception if
> that column has a value of "Toad" or "SQL*Plus". That would be
> much more effective then PRODUCT_USER_PROFILE.
>
> --
> Mladen Gogala
> Oracle DBA
> email:mladeng_at_aetvn.com
> Ext: 9787
>
>

>> -----Original Message-----
>> From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com]
>> Sent: Thursday, August 12, 2004 4:55 PM
>> To: oracle-l_at_freelists.org
>> Subject: RE: PUP table
>> 
>> 
>> David,
>> 
>> As you discovered, PRODUCT_USER_PROFILE only limits people
>> using = SQL*Plus as the client tool.  TOAD does not look at
>> or care about the = contents of the PRODUCT_USER_PROFILE
>> table.  If you want to restrict = non-SQL*Plus users from
>> certain activities, you'll have to revoke = privleges and
>> roles from the user(s).


> ----------------------------------------------------------------

> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Aug 12 2004 - 22:44:20 CDT