RE: user name with underscore gives problems

From: John Dunn <john.dunn_at_sefas.co.uk>
Date: Fri, 19 Mar 2004 10:51:44 -0000
Message-ID: <A05E0089719FD311911400A0249EE7E5BD24C3@guest-wv-50.ripe.net>

dbms_java.grant_permission is an Oracle supplied package so I would expect it to work.

John

-----Original Message-----
From: sfaroult_at_oriole.com [mailto:sfaroult_at_oriole.com] Sent: Friday, March 19, 2004 5:39 AM
To: oracle-l_at_freelists.org
Subject: Re: user name with underscore gives problems

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',
> > '<<ALL)
> > *
> > 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_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
> -----------------------------------------------------------------

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_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 Fri Mar 19 2004 - 04:38:56 CST