使用Oracle外部身份认证增强安全性

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE
oracle@ythdc:/home/oracle$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 31 15:41:12 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameters authent

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix                    string      ops$
remote_os_authent                    boolean     FALSE

SQL> create user ops$test identified by externally;   //ops$test对应的操作系统用户是test

User created.

SQL> grant connect to ops$test;

Grant succeeded.

SQL> exit

root@ythdc:/home# su - test

test@ythdc:/home/test$ sqlplus /

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 31 15:44:27 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

SQL> show user
USER is "OPS$TEST"
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23135684/viewspace-630560/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23135684/viewspace-630560/