From oracle-l-bounce@freelists.org Thu Apr 22 10:24:47 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3MFOlv03410 for ; Thu, 22 Apr 2004 10:24:47 -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 i3MFOk603405 for ; Thu, 22 Apr 2004 10:24:47 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3E7A972EC3B; Thu, 22 Apr 2004 10:02:29 -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 21552-82; Thu, 22 Apr 2004 10:02:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4927E72EFD0; Thu, 22 Apr 2004 09:48:30 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 22 Apr 2004 09:47:10 -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 52ED472D92C for ; Thu, 22 Apr 2004 09:41:43 -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 17349-72 for ; Thu, 22 Apr 2004 09:41:43 -0500 (EST) Received: from enhbgsmtp02.state.pa.us (ENHBGSMTP02.state.pa.us [206.224.21.48]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9802A72E58D for ; Thu, 22 Apr 2004 09:29:17 -0500 (EST) Received: from ENHBGPRI11.PA.LCL ([206.224.21.35]) by enhbgsmtp02.state.pa.us with Microsoft SMTPSVC(5.0.2195.6713); Thu, 22 Apr 2004 10:41:01 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: quick pl/sql question Date: Thu, 22 Apr 2004 10:41:00 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: quick pl/sql question Thread-Index: AcQoaWepK9MnrbZLSjuKaZgS4TPo2gAAs87QAACe1gAAAL6VoAAA80OA From: "Freeman, Donald" To: X-OriginalArrivalTime: 22 Apr 2004 14:41:01.0239 (UTC) FILETIME=[D4F6F470:01C42877] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3579 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dofreeman@state.pa.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Well, get rid of the authid current user since that part doesn't work = for your needs. If cerebrus is going to own the procedure then that's = the one who needs select on whatever table or view is buried in there. = In my case I explicitly granted select on tables like dba_users (or the = underlying tables) to the proc owner.=20 The package code is wrapped so I couldn't figure out exactly what = objects can't be seen. You could try creating the object in sys schema = instead of cerebrus and then granting execute on it. This thing can be = made to work but maybe not in conformance with acceptable practices. I = have been referring to Scott Urman's 8i Advanced PL/SQL Programming = Book. =20 The key line in the book for this problem is, "A subprogram executes = under the privileges that have been granted explicitly to it's owner, = not via a role." I'm guessing Hangdam is like a security/admin person? Can user Hangdam = execute dbms_resource_manager_privs.grant_switch_consumer_group outside = of the proc? >=20 >=20 > Thanks again, still not working though >=20 >=20 ---------------------------------------------------------------- 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 -----------------------------------------------------------------