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: TOAD Xpert privileges

Re: TOAD Xpert privileges

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 14 Jul 2004 15:53:40 -0400
Message-Id: <s0f55723.032@galottery.org>


Dennis,
 Would there be a problem if the developers had the privileges listed? After all they
only have access to the development server. They might learn to configure the packages
 and tables and associated info correctly if they used the TOAD to show them the
error in thier ways.
Ron

>>> DWILLIAMS_at_LIFETOUCH.COM 07/14/2004 11:47:53 AM >>> 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_at_lifetouch.com=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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/ 
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jul 14 2004 - 14:51:07 CDT

Original text of this message

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