From oracle-l-bounce@freelists.org Wed Jul 14 10:50:51 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6EFoQ322578 for ; Wed, 14 Jul 2004 10:50:36 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6EFo6622483 for ; Wed, 14 Jul 2004 10:50:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A59B72CD06; Wed, 14 Jul 2004 10:29:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01800-65; Wed, 14 Jul 2004 10:29:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 95A6272D2CF; Wed, 14 Jul 2004 10:29:27 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 14 Jul 2004 10:28:00 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CEC0A72D17E for ; Wed, 14 Jul 2004 10:27:59 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01800-30 for ; Wed, 14 Jul 2004 10:27:59 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id E4B9572CCC3 for ; Wed, 14 Jul 2004 10:27:58 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 14 Jul 2004 15:56:56 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B009F2@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: TOAD Xpert privileges Date: Wed, 14 Jul 2004 10:47:53 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5079 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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@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 -----------------------------------------------------------------