Re: user name with underscore gives problems
- From: <sfaroult@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- 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',
> > '<<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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
