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: Third Party tool rant

Re: Third Party tool rant

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 05 Jan 2007 12:57:47 -0700
Message-Id: <20070105195803.2F1AD584C47@turing.freelists.org>


Why not grant the toad users SELECT_CATALOG_ROLE. Probably not ideal, but a heck of a lot better than DBA.

9.2.0.7> grant connect, create session to guest identified by guest;

Grant succeeded.

9.2.0.7> connect guest/guest_at_ora92
9.2.0.7> select count(0) from all_tables;

   COUNT(0)


         33

1 row selected.

9.2.0.7> select count(0) from dba_tables; select count(0) from dba_tables

                      *

ERROR at line 1:
ORA-00942: table or view does not exist

Grant succeeded.

SQL>


9.2.0.7> select count(0) from dba_tables; select count(0) from dba_tables

                      *

ERROR at line 1:
ORA-00942: table or view does not exist

9.2.0.7> connect guest/guest_at_ora92
Connected.
9.2.0.7> select count(0) from dba_tables;

   COUNT(0)


      28396

1 row selected.

9.2.0.7>

Works too in 10g (10.1.0.5, don't have a 10.2 handy at the moment).

At 12:20 PM 1/5/2007, Richard J. Goulet wrote:
>Folks,
>
> Pardon me, but I just got to let this out before I start
> thinking about mailing a letter bomb or some other sort of
> retribution. I've got a number of duhvelopers, with an emphasis on
> the duh, that use Toad. Now every once in a while these folks just
> have to call Quest tech support for some assistance, like
> integrating PVCS. Well every time they do that the Quest tech
> folks inform them that they NEED DBA priviledges in the
> database. It's a major pain in the neck with my having to repair
> something there after, like restoring a tablespace that they
> dropped. Is there anyone out there having similar problems? And
> if there are any Quest folks on the list, which I believe there
> are, how about tweaking the tool so that DBA is NOT needed. I mean
> replace all those calls to DBA_this and that with ALL_.
>
><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
>
>[]
>
>Dick Goulet, Senior Oracle DBA
>
><?xml:namespace prefix = st1 ns =
>"urn:schemas-microsoft-com:office:smarttags" />45 Bartlett
>St Marlborough, Ma 01752, USA
>Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795
>
><mailto:RGoulet_at_kanbay.com>RGoulet_at_kanbay.com
>: POWERING TRANSFORMATION
>
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com



This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

--
http://www.freelists.org/webpage/oracle-l


Received on Fri Jan 05 2007 - 13:57:47 CST

Original text of this message

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