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: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 17 Jan 2003 10:25:04 -0800
Message-ID: <F001.00533471.20030117102504@fatcity.com>


Rao,  

why? why prevent them from using a tool?  

do they have privs to do anything? if so, then you have bigger problems.  

the tool is never the issue. the issue is what database account they are using to connect with. if they have privs to change objects, then the tool does not matter - they can learn to do it using sqlplus.  

take away dba privs from them, or change the password. and give them a developers account.  

hope this helps.  

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, January 17, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L

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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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 - 12:25:04 CST

Original text of this message

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