Re: user name with underscore gives problems

From: <sfaroult_at_oriole.com>
Date: Fri, 19 Mar 2004 05:39:02 -0500 (EST)
Message-Id: <20040319103242.44F4A390A55@turing.freelists.org>

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
-----------------------------------------------------------------

Received on Fri Mar 19 2004 - 04:35:28 CST