使用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>