From oracle-l-bounce@freelists.org Thu Apr 22 08:35:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3MDZw803983 for ; Thu, 22 Apr 2004 08:35:58 -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 i3MDZw603978 for ; Thu, 22 Apr 2004 08:35:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6B5D72CE34; Thu, 22 Apr 2004 08:28:40 -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 02417-52; Thu, 22 Apr 2004 08:28:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1195E72CE1B; Thu, 22 Apr 2004 08:28:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 22 Apr 2004 08:27:27 -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 0553872D16C for ; Thu, 22 Apr 2004 08:27:27 -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 02417-31 for ; Thu, 22 Apr 2004 08:27:26 -0500 (EST) Received: from ahmet.cerebrussolutions.com (unknown [194.202.36.50]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 87A5B72D063 for ; Thu, 22 Apr 2004 08:27:25 -0500 (EST) Received: from louis.cerebrus.com ([192.168.2.1]) by ahmet.cerebrussolutions.com (SAVSMTP 3.1.5.43) with SMTP id M2004042214470504084 for ; Thu, 22 Apr 2004 14:47:05 +0100 Content-class: urn:content-classes:message Subject: RE: quick pl/sql question MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Date: Thu, 22 Apr 2004 14:42:23 +0100 Message-ID: X-MIMEOLE: Produced By Microsoft Exchange V6.5.6944.0 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: quick pl/sql question thread-index: AcQnu2ACYlselQdsRXCmgk/4UzeXPAAAJPXQAAIdFBAABOYSSAAdrtPQAAaFnrAAAVnrYAAAVJOg From: "David Sharples" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3564 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dsharples@cerebrussolutions.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Absolutely Uts my package, but someone else is going to execute it. It could be a number of people so I cant create the package in their schemas either -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Freeman, Donald Sent: 22 April 2004 14:34 To: oracle-l@freelists.org Subject: FW: quick pl/sql question OK, so it's not you who is going to execute this. It works when you do =3D it but not when someone else does it? CREATE OR REPLACE PROCEDURE dave_test (p_user_id IN VARCHAR2)=3D20 AUTHID CURRENT_USER AS BEGIN =3D20 =3D dbms_resource_manager_privs.grant_switch_consumer_group(p_user_id,'users 1=3D ',TRUE); =20 dbms_resource_manager.set_initial_consumer_group(p_user_id,'users1'); END; / ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------