Oracle允许通过外部身份认证创建用户，这样登陆时可以不需要输入口令，从而提高安全性。
以下是Linux中测试的例子.
[oracle@jumper oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Mar 21 09:44:03 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
show
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> show parameters os_authent_prefix
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix string ops$
SQL> create user ops$gqgai identified externally;
User created.
SQL> grant connect to ops$gqgai;
Grant succeeded.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
[oracle@jumper oracle]$ su - gqgai
Password:
[gqgai@jumper gqgai]$ sqlplus /
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Mar 21 10:08:00 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> show user
USER is "OPS$GQGAI"
SQL>
|
简单测试，仅供参考。
