"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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
