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@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
==== in between here the following happened from a different session:
=======================
SQL> grant select_catalog_role to guest;
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@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, USATel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795 <mailto:RGoulet@xxxxxxxxxx>RGoulet@xxxxxxxxxx : POWERING TRANSFORMATION
Regards Wolfgang Breitling Centrex Consulting Corporationwww.centrexcc.com
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System.For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
