windows平台Oracle数据库对username,password的大小写限制

1. 在数据字典内，所有的用户名缺省都用大写；同时区分大小写
2. 使用双引号可以强制数据字典内用创建时的大小写。但登录时必须也用双引号
3. 密码，无论是否使用双引号，都是大小写无关的
4. 不用栓引号，创建时是大写的，可以用小写登录

创建时是小写的，只能用小写

 

 

C:/>set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

 

C:/>sqlplus system/mercurypw@pcdb95

 

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 12月 4 00:58:04 2009

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Release 10.2.0.1.0 - Production

 

SQL> create user "PCdB001" identified by MIOrchid#1;

 

User created.

 

SQL> grant connect, resource to "PCdB001";

 

Grant succeeded.

 

SQL> conn PCdB001/MIOrchid#1@pcdb95

ERROR:

ORA-01017: invalid username/password; logon denied

 

 

Warning: You are no longer connected to ORACLE.

 

SQL> conn system/mercurypw@pcdb95

Connected.

SQL> select username from dba_users where username like 'PCDB%';

 

USERNAME

------------------------------

PCDB95

 

SQL> select username from dba_users where username like 'PCdB%';

 

USERNAME

------------------------------

PCdB001

 

SQL> conn "PCdB001/MIOrchid#1"@pcdb95

Enter password:

ERROR:

ORA-01017: invalid username/password; logon denied

 

 

Warning: You are no longer connected to ORACLE.

SQL> conn "PCdB001"/MIOrchid#1@pcdb95

Connected.

SQL> conn "PCdB001"/miorchid#1@pcdb95

Connected.

SQL> conn system/mercurypw@pcdb95

Connected.

SQL> create user pcdb001 identified by "MIOrchid#1";

 

User created.

 

SQL> grant connect, resource to pcdb001;

 

Grant succeeded.

 

SQL> conn pcdb001/miorchid#1@pcdb95

Connected.

SQL>

SQL> conn pcdb001/MIOrchid#1@pcdb95

Connected.

SQL> conn PCDB001/MioCHID#1@pcdb95

ERROR:

ORA-01017: invalid username/password; logon denied

 

 

Warning: You are no longer connected to ORACLE.

SQL> conn system/mercurypw@pcdb95

Connected.

SQL> select username from dba_users where username like 'PCDB%';

 

USERNAME

------------------------------

PCDB95

PCDB001

 

SQL> select username from dba_users where username like 'pcdb%';

 

no rows selected

 

SQL>

SQL> create user "PCDB111" identified by MIORCHID#1;

 

User created.

 

SQL> grant connect, resource to "PCDB111";

 

Grant succeeded.

 

SQL> conn PCDB111/miorchid#1@pcdb95

Connected.

SQL> conn system/mercurypw@pcdb95

Connected.

SQL> select username from dba_users where username like "PCDB%";

select username from dba_users where username like "PCDB%"

                                                   *

ERROR at line 1:

ORA-00904: "PCDB%": 标识符无效

 

 

SQL> select username from dba_users where username like 'PCDB%';

 

USERNAME

------------------------------

PCDB95

PCDB001

PCDB111

 

SQL> conn pcdb111/miorchid#1@pcdb95

Connected.

SQL> conn system/mercurypw@pcdb95

Connected.

SQL> select username from dba_users where username like 'pcdb%';

 

no rows selected

 

SQL>