RE: Toad connections

["Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>]

This *may* work, but is unreliable because the path to the exe can be longer 
than Oracle can store in the PROGRAM column of V$SESSION, thereby obscuring the 
name of the program.  I see this with many Windohs programs like TOAD and MS 
Access, where the end-user can alter their own environment (e.g. Start Menu and 
Shortcuts).
Your best bet is to first create a TOAD.TOAD_FREEWARE table with a single 
VARCHAR2(2000) column and GRANT SELECT TO PUBLIC on that table.  Populate it 
with a single row with a message that users of the freely downloadable TOAD 
will see stating that they can't and shouldn't use it!

Next, your logon trigger should look at the MODULE column of V$SESSION.  Older 
versions of TOAD will have "T.O.A.D.".  Newer ones will have "TOAD <version>" 
(at my request, thanks to the wonderfully responsive TOAD development team!).  
You'll probably need to check for both.

HTH!  GL!


Rich



-----Original Message-----
Sent: Wednesday, September 01, 2004 2:46 AM
Subject: Re: Toad connections



Try to validate in on logon trigger & check if program is Toad.exe

Regards
Pawan Dalmia



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts:

Toad connections

Re: Toad connections

Re: Toad connections

RE: Toad connections