RE: Third Party tool rant

From: Kerber, Andrew <Andrew.Kerber_at_umb.com>
Date: Fri, 5 Jan 2007 13:32:22 -0600
Message-ID: <D40740337A3B524FA81DB598D2D7EBB30577701C@x6009a.umb.corp.umb.com>

They don't need DBA access. select_catalog_role or select any dictionary is sufficient, and even those aren't needed if you just give grants to the specific dba views that Toad uses. The people at Quest know this, and should know that you don't give dba privs to every developer.

Andrew W. Kerber
Oracle DBA
UMB
816-860-3921
andrew.kerber_at_umb.com

"If at first you dont succeed, dont take up skydiving"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Richard J. Goulet Sent: Friday, January 05, 2007 1:21 PM
To: oracle-l_at_freelists.org
Subject: Third Party tool rant

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_.

Dick Goulet, Senior Oracle DBA

45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795

RGoulet_at_kanbay.com
: POWERING TRANSFORMATION

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

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

Received on Fri Jan 05 2007 - 13:32:22 CST