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: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 14 Jul 2004 13:24:08 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B009F8@EXCHMN3>


Tom - Thanks, as always. You have provided a great deal of wisdom in this reply.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F Sent: Wednesday, July 14, 2004 1:16 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: TOAD Xpert privileges

Dennis,

I have some end-users that bought Toad and they do not have these privs. They have not even created the Toad Schema objects. They do not need to do this to use Toad, and I agree with you - they would not get those privs in any environment of mine.

Just because they bought something doesn't mean they get to use all of the functions.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Wednesday, July 14, 2004 12:36 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: TOAD Xpert privileges

Mark - Meaning I get suspicious of any package that insists on extensive privileges. I credit this suspicious nature for my continued employment as a DBA. Tony - So you are saying that I need to create a schema with these extensive privileges but somehow I don't have to give that password to the developers? Is there a way to reduce the privileges after object installation?

   You say that you've found TOAD pretty safe. I would be much comforted if you said you found TOAD Xpert to be safe.

   Thanks for your input.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----

From: Aponte, Tony [mailto:AponteT_at_hsn.net] Sent: Wednesday, July 14, 2004 11:35 AM
To: oracle-l_at_freelists.org
Cc: DENNIS WILLIAMS
Subject: RE: TOAD Xpert privileges

I think the snippet refers to the installation of the objects. The TOAD user doesn't have to use schema that owns the objects in order to take advantage of the tool. We've found that TOAD is pretty safe to deploy to production environments.

HTH
Tony Aponte
Home Shopping Network



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

-----------------------------------------------------------------
----------------------------------------------------------------
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 - 13:28:34 CDT

Original text of this message

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