RE: Prevent connections for some users through SQL*Plus, TOAD

Raise an exception in that trigger and all users without "administer database trigger" privilege can't connect anymore.  

But if you need to do such things you should really review your security policy - as if you enforce security by checking client executable name, then anyone who can change client executable name (all users!) can work around your policy.

--

Regards,
Tanel Poder
 <http://blog.tanelpoder.com/> http://blog.tanelpoder.com  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ricardo Santos
Sent: Monday, June 02, 2008 19:48
To: ORACLE-L
Subject: Prevent connections for some users through SQL*Plus, TOAD

Hello to you all,

I've an old fashion application that uses an Oracle Database where each application user, is also a database user. That way, each user can connect to the database through other tools beside the application, like TOAD, SQL*Plus, etc.  

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 02 2008 - 08:48:07 CDT