RE: Toad connections

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Wed, 1 Sep 2004 09:30:30 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93CF8@qtiexch2.qgraph.com>

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_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 Wed Sep 01 2004 - 11:15:37 CDT