RE: user name with underscore gives problems

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 19 Mar 2004 10:46:16 -0000
Message-ID: <003801c40d9f$6a5a7210$04fea8c0@mark>

Hi John,

We use a user called NORAD_USER that's used for our monitoring tools, that has no adverse effects that I have come across.. We also have a number of users in our test systems that have underscores in their user name as well. Perhaps it's a java problem?

Have you tried connecting with the user through SQL*Plus?

NORAD_USER @ orcl:
SQL> select username
  2 from dba_users
  3 where username like 'NORAD%'
  4 or username like 'QS%';

USERNAME

QS_ADM
QS_CB
QS_CBADM
QS_CS
QS_ES
QS_OS
QS_WS

NORAD_USER 9 rows selected.

Mark

Mark Leith
Cool-Tools UK Limited

Tel: 01905 330 281
Fax: 08701 275 283
mark_at_cool-tools.co.uk
http://www.cool-tools.co.uk

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn Sent: 19 March 2004 10:36
To: oracle-l_at_freelists.org
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_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
-----------------------------------------------------------------

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004
 

----------------------------------------------------------------
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:40:42 CST