使用Oracle外部身份认证，提高系统安全性

[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> 
复制