Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0I1b4803196 for ; Fri, 17 Jan 2003 19:37:04 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0I1b4p03191 for ; Fri, 17 Jan 2003 19:37:04 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id OAA62432; Fri, 17 Jan 2003 14:17:56 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00533924; Fri, 17 Jan 2003 13:59:28 -0800 Message-ID: Date: Fri, 17 Jan 2003 13:59:28 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Todd Carlson" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Todd Carlson" Subject: RE: Limiting user connections with DBA Studio Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--=_NextPart_ST_15_57_08_Friday_January_17_2003_15249" ----=_NextPart_ST_15_57_08_Friday_January_17_2003_15249 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit You should kill the previous DBA too. ;-) Todd -----Original Message----- maheswara.rao@sungard.com Sent: Friday, January 17, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Todd, The previous DBA has granted them almost all the privileges except DBA privilege. Now, when we tried to take away this SELECT_CATALOG_ROLE, then, these specific users started raising alarms. So, what we are planning is to kill their session the moment we find that they are using DBA Studio. Rao -----Original Message----- Sent: Friday, January 17, 2003 2:10 PM To: Multiple recipients of list ORACLE-L They can't use it unless they can select from the data dictionary views. For example, if they don't the SELECT_CATALOG_ROLE role or DBA privs in 8.1.7 they can not use DBA Studio. Todd -----Original Message----- maheswara.rao@sungard.com Sent: Friday, January 17, 2003 11:09 AM 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 ----=_NextPart_ST_15_57_08_Friday_January_17_2003_15249 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable RE: Database Verification

You should kill the previous DBA too. = ;-)

 

Todd

 

-----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com] On Behalf Of = maheswara.rao@sungard.com
Sent: Friday, January 17, 20= 03 2:24 PM
To: Multiple recipients of l= ist ORACLE-L
Subject: RE: Limiting user connections with DBA Studio

 

Todd,=

 

The previous DBA ha= s granted them almost all the privileges except DBA privilege.  Now, whe= n we tried to take away this SELECT_CATALOG_ROLE, then, these specific users sta= rted raising alarms.

 

So, what we are pla= nning is to kill their session the moment we find that they are using DBA Studio. 

 

Rao

-----Original Message-----
From: Todd Carlson [mailto:tcarlson@TRIPOS.COM]
Sent: Friday, January 17, 20= 03 2:10 PM
To: Multiple recipients of l= ist ORACLE-L
Subject: RE: Limiting user connections with DBA Studio

They can’t us= e it unless they can select from the data dictionary views. For example, if they don’t the SELECT_CATALOG_ROLE role or DBA privs in 8.1.7 they can not= use DBA Studio.

 

Todd

 

-----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com] On Behalf Of = maheswara.rao@sungard.com
Sent: Friday, January 17, 20= 03 11:09 AM
To: Multiple recipients of l= ist ORACLE-L
Subject: Limiting user conne= ctions with DBA Studio

 

= 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 thinkin= g of using on_logon trigger but no clue how to catch the connection.

 

= Any suggestions?

 

= Rao

----=_NextPart_ST_15_57_08_Friday_January_17_2003_15249-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Carlson INET: tcarlson@TRIPOS.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@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).