Meaning you would hesitate to install Toad on a production system, right? For test (not QA or acceptance) and development systems, why not? Of course this implies that you have a secure process for managing users and privileges from dev to test to QA to acceptance to production, etc.... mwf -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS Sent: Wednesday, July 14, 2004 11:48 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: TOAD Xpert privileges List - Someone here purchased TOAD Xpert for a couple of the = developers. The following is an excerpt from the Quest manual. Is this for real? Should anyone besides a DBA be using this tool? Is anyone else on the list = willing to admit doing this for one of their developers? Dennis Williams DBA Lifetouch, Inc. dwilliams@xxxxxxxxxxxxx=20 I said it "looked" clear - Riddick To succussfully run the object installation scripts, the schema should = have the following roles/privileges. The individual privileges need to be = granted explicitly instead of using the DBA role. These privileges are not recognized from the role when using packages. =B7 DBA =B7 Create Any Synonym =B7 Drop Any Synonym =B7 Create Role =B7 Create Any Procedure =B7 Create Any Table Quest Central =A92002 Quest Software, Inc. =09 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------