From oracle-l-bounce@freelists.org Fri Mar 19 04:35:28 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2JAZRU03106 for ; Fri, 19 Mar 2004 04:35:27 -0600 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 i2JAZRo03101 for ; Fri, 19 Mar 2004 04:35:27 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 21221390A78; Fri, 19 Mar 2004 05:33:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 19 Mar 2004 05:32:42 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail01g.rapidsite.net (mail01g.rapidsite.net [208.55.43.104]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 44F4A390A55 for ; Fri, 19 Mar 2004 05:32:42 -0500 (EST) Received: from www.oriolecorp.com (209.130.76.151) by mail01g.rapidsite.net (RS ver 1.0.91vs) with SMTP id 2-0876262742 for ; Fri, 19 Mar 2004 05:39:02 -0500 (EST) To: oracle-l@freelists.org From: Subject: Re: user name with underscore gives problems Date: Fri, 19 Mar 2004 05:39:02 -0500 (EST) X-Mailer: Endymion MailMan Professional Edition v3.0.26 X-Loop-Detect: 1 Message-Id: <20040319103242.44F4A390A55@turing.freelists.org> X-archive-position: 1219 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sfaroult@oriole.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Orig-Date: Fri, 19 Mar 2004 05:39:03 EST5EDT John, Username (and passwords) follow the usual identifier naming rules, and therefore the underscore character, as well as $ or #, are perfectly valid except in the first position. What may occur in your routine is some username transformation which would be more stringent than Oracle rules. But are you sure that 'io.FilePermission' refers to things occurring WITHIN oracle ? HTH, SF > > > I get the following error with the user name my_user. The user name > > my_user exists. It works OK if the user name is myuser(that also exists). > > Is the underscore giving Oracle problems? > > > > > > call dbms_java.grant_permission('my_user', 'SYS:java.io.FilePermission', > > '< > * > > ERROR at line 1: > > ORA-29532: Java call terminated by uncaught Java exception: > > oracle.aurora.vm.IdNotFoundException: my_user is not a user or role > > > > John > > > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- -- Oracle scripts, papers and DBA Tools -- -- Oriole Corporation -- -- http://www.oriole.com/ -- ---------------------------------------------------------------- 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 -----------------------------------------------------------------