RE: Blocking "illegal" connections

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 12 Dec 2001 16:15:38 -0800
Message-ID: <F001.003DB646.20011212160041@fatcity.com>

If you are trying to stop business users from connecting to the application data using these tools then you need application authentication not database authentication (application IDs not DB IDs).

But if you are only interested in stopping users from using "illegal" tools then the only thing I could say Good Luck except you're using n-tier where you can filter out connecting nodes.

Regards,

Waleed

-----Original Message-----

Sent: Wednesday, December 12, 2001 5:20 PM To: Multiple recipients of list ORACLE-L

Hi,

We're trying to prevent users from connecting to our production database via "illegal" connections (i.e. tools like TOAD, etc.).

Does anyone have any suggestions on how to block connections from query tools (i.e. Toad, SQL Nav, etc.) in such a way that an error message is reported back to the tool user that the connection is prohibited? We've tried designing a logon trigger with a PRAGMA definition but the error message is not getting relayed back to the client.

As always, your feedback is appreciated!
-w

---

Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com
--

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

Author: Walter K
  INET: alden14004_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

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

Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 12 2001 - 18:15:38 CST