Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Limiting user connections with DBA Studio

Re: Limiting user connections with DBA Studio

From: Arup Nanda <arupnanda_at_hotmail.com>
Date: Fri, 17 Jan 2003 14:43:40 -0800
Message-ID: <F001.00533974.20030117144340@fatcity.com>


I agree with Kirti. Why prevent them from using DBA Studio? If you have given them the privilege, then they can easily connect through sql plus or some other tool, not necessarily through DBA Studio. So it's better to control their actions through proper grants.

Arup

> But the fundamental question is why prevent them.
> What damage are they causing?
> Control their actions via proper permissions.
> If OEM installation is against Company policy (or "they did not ask the
Oracle DBA Group"), then the problem should be addressed via other administrative procedures.
>
> - Kirti
>
> > 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.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).
Received on Fri Jan 17 2003 - 16:43:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US