RE: user name with underscore gives problems
- From: John Dunn <john.dunn@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 19 Mar 2004 10:51:44 -0000
dbms_java.grant_permission is an Oracle supplied package so I would expect
it to work.
John
-----Original Message-----
From: sfaroult@xxxxxxxxxx [mailto:sfaroult@xxxxxxxxxx]
Sent: Friday, March 19, 2004 5:39 AM
To: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
