Re: Limiting user connections with DBA Studio

> maheswara.rao_at_sungard.com wrote:
>
> Some of our users installed OEM on their local PC's. They connect to
> the database through DBA Studio.
>
> Is there any way to prevent DBA Studio connections to the server? I
> am thinking of using on_logon trigger but no clue how to catch the
> connection.
>
> Any suggestions?
>
> Rao

Rao,

  Check (in V$SESSION) whether DBA Studio sets something in the MODULE column (SQL*Plus does it, TOAD does it, what I write does it, usually :-)). I have often used this in triggers to authorize some operations through some specific programs exclusively (or by cheating under SQL*Plus) - you just have to call dbme_application_info.read_module. However (sorry, I have not checked it) it is highly likely that the on_logon trigger may fire before MODULE is set, since you must be connected to call dbms_application_info.set_module. If it is set later, you may use some killer job which checks from time to time and kills session. Not very elegant, you cannot guarantee that users will not have the time to do anything, but ...
Something which may be worth exploring, too, is whether DBA Studio makes use of PRODUCT_USER_PROFILE.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).