Using a '.' in a username

From: Lee, Peter (AZ15) <peter.lee_at_honeywell.com>
Date: Mon, 15 Dec 2003 07:49:25 -0800
Message-ID: <F001.005D9F70.20031215074925@fatcity.com>

All,

Is a '.' in the Oracle username legal in 8.1.7?

I can create an account as follows:

SQL>CREATE USER "PETER.LEE" idenfied by password;

SQL>GRANT DBA TO "PETER.LEE" SQL>CONN PETER.LEE/password@[database alias];

SQL> select * from user_role_privs;

USERNAME                       GRANTED_ROLE                   ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
PETER.LEE                      DBA                            NO  YES NO

However, I cannot connect using:

SQLPLUS "PETER.LEE"/password@[database alias]

SQLPLUS PETER.LEE/password@[database alias]

I reviewed the Oracle documentation. It mention that username must be a maximum of 30 characters but it does not mention what are the allowable characters in the username.

Does anyone know whether a '.' is an allowable character in Oracle username?

Thank you in advance.

Pete
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Lee, Peter (AZ15)
  INET: peter.lee_at_honeywell.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 15 2003 - 09:49:25 CST