Re: How to stop access to prod instance ...

"Jamadagni, Rajendra" wrote:
>
> How does one stop access to prod instance by any product other than supplied
> homegrown Forms application?
>
> I mean no sqlplus, toad, tora and similar tools and their renamed
> derivatives?? All this needs to be done for all users incl developers except
> DBAs.
>
> Thanks in advance
> Raj
>

Besides everything which has been suggested, another thing which _may_ work is to use a login trigger which checks the environment (V$SESSION), and more specifically which program runs, and raises an error if it doesn't happen to be what is allowed. The snag is that the information in 'program' is not always sufficient (can be a DLL name), and the trigger fires too early to be able to check something set by dbms_application_info().

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).