基於外部OS驗證的資料庫使用者

liuhaimiao發表於2017-01-23

採用操作外部系統認證(unix or linux 等 OS)
SQL> show parameters os_authent_prefix

NAME TYPE VALUE
------------------------------------ ----------- ------------------------
os_authent_prefix string OPS$
SQL> CREATE USER "OPS$ORACLE" PROFILE "DEFAULT"
IDENTIFIED EXTERNALLY DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";

User created.

SQL> grant connect to ops$oracle;

Grant succeeded.

SQL> conn /
Connected.
SQL>
SQL> show user
USER is "OPS$ORACLE"
SQL>
SQL> exit
Disconnected from Oracle10i Enterprise Edition Release 10.1.0.0.0 - Beta
With the Partitioning, OLAP and Oracle Data Mining options
[oracle@linux oracle]$ sqlplus /

SQL*Plus: Release 10.1.0.0.0 - Beta on Tue Aug 19 16:04:46 2003

Copyright (c) 1982, 2003, Oracle Corporation. All rights reserved.


Connected to:
Oracle10i Enterprise Edition Release 10.1.0.0.0 - Beta
With the Partitioning, OLAP and Oracle Data Mining options

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


建立使用者的時候名稱為 os_authent_prefix + OS NAME
這樣當該 os name 登陸資料庫的時候只要使用 / 就可以了

通常 userid = user/pass
現在 userid = /

 

windows下稍微有點差異,請去 www.itpub.net 搜尋

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/223653/viewspace-2132833/,如需轉載,請註明出處,否則將追究法律責任。

相關文章