Using a '.' in a username

2003-12-15 Thread Lee, Peter (AZ15) 
All,

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

I can create an account as follows:

SQLCREATE USER PETER.LEE idenfied by password;

SQLGRANT DBA TO PETER.LEE

SQLCONN PETER.LEE/[EMAIL PROTECTED] alias];

SQL select * from user_role_privs;

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

However, I cannot connect using:

SQLPLUS PETER.LEE/[EMAIL PROTECTED] alias]

SQLPLUS PETER.LEE/[EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Need help with an error ORA-12640

2003-08-28 Thread Lee, Peter (AZ15) 
 Guru:
 
 I need help with an error ORA-12640.
 
 I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000.
 The sqlnet.authentication_services=(NTS) parameter is enabled and we do
 not want to change the sqlnet.authentication_services=(NONE).
 
 The custom SQL application is launched by a Domain User on the Oracle
 Server machine.  If the Domain user has local administrative privileges,
 it works with no error.  If the Domain user does not have local
 adminstrative privileges, it fails with the above error.
 
 I am at a lost to explain this.   Does anyone has any idea?
 
 Thank you in advance.
 
 Pete
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lee, Peter (AZ15)
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Need help with an error ORA-12640

2003-08-28 Thread Lee, Peter (AZ15) 
Jarad:

username/password

Thank in advance,

Pete

-Original Message-
Sent: Thursday, August 28, 2003 8:15 AM
To: Multiple recipients of list ORACLE-L



How does the application connect to the database?

username/password or '/'?

Jared

On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15) wrote:
  Guru:
  
  I need help with an error ORA-12640.
  
  I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows
2000.
  The sqlnet.authentication_services=(NTS) parameter is enabled and we do
  not want to change the sqlnet.authentication_services=(NONE).
  
  The custom SQL application is launched by a Domain User on the Oracle
  Server machine.  If the Domain user has local administrative privileges,
  it works with no error.  If the Domain user does not have local
  adminstrative privileges, it fails with the above error.
  
  I am at a lost to explain this.   Does anyone has any idea?
  
  Thank you in advance.
  
  Pete
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Lee, Peter (AZ15)
   INET: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lee, Peter (AZ15)
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).