Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Third Party tool rant
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
*
Grant succeeded.
SQL>
9.2.0.7> select count(0) from dba_tables; select count(0) from dba_tables
*
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 05 2007 - 13:57:47 CST
- application/octet-stream attachment: 3d48108.gif
![]() |
![]() |