Thanks Feighery That worked. John -----Original Message----- From: Feighery Raymond [mailto:Raymond.Feighery@xxxxxxxxxxxxx] Sent: Friday, March 19, 2004 10:47 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: user name with underscore gives problems dbms_java.grant_permission seems to be case-sensitive: SQL> create user my_user identified by my_user 2 default tablespace users 3 temporary tablespace temp 4 / User created. SQL> grant connect to my_user 2 / Grant succeeded. SQL> call dbms_java.grant_permission('my_user','SYS:java.io.FilePermission','/tmp/*',' read,write'); call dbms_java.grant_permission('my_user','SYS:java.io.FilePermission','/tmp/*',' read,write') * 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 SQL> call dbms_java.grant_permission('MY_USER','SYS:java.io.FilePermission','/tmp/*',' read,write'); Call completed. SQL> commit; Commit complete. Ray -----Original Message----- From: John Dunn [mailto:john.dunn@xxxxxxxxxxx] Sent: Friday, March 19, 2004 10:36 AM To: oracle-l@xxxxxxxxxxxxx Subject: user name with underscore gives problems > 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 ----------------------------------------------------------------- ___________________________________________________________________________ This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. ---------------------------------------------------------------- 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 -----------------------------------------------------------------