Re: Prevent connections for some users through SQL*Plus, TOAD
- From: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 02 Jun 2008 21:51:27 +0400
If this helps, basic example..
http://www.amar-padhi.com/oradb_secure_app_roles.html
thanks!
amar
Ricardo Santos wrote:
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.
For security reasons I would like to prevent these users to connect to
the database using any other program than the application itself(No
SQL*Plus, no Toad, etc …). I thought in using a "trigger after logon"
with a kill session statement, but it's true :) a session can't kill
itself (ORA-00027)
At the moment I'm not figuring out a way to achieve what I want. Can
anyone give me a hand ?
Thanks in advance,
Ricardo Bateiras.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
