HowTo:  Create an Oracle External Authentication user

【解决方案】

SQL> show user
USER is "SYSTEM"

SQL> show parameter os_authent_prefix

NAME TYPE VALUE
------------------- ----------- ---------
os_authent_prefix string OPS$


SQL> create user "OPS$yourDOMAINNAME\yourUSERNAME" identified externally default tablespace USERS temporary tablespace TEMP account unlock;

SQL> grant connect, resource, create view, unlimited tablespace to "OPS$yourDOMAINNAME\yourUSERNAME";

SQL> commit;


If the 'os_authent_prefix' initialization parameter has a value of NULL in the Oracle instance, create the user without the 'OPS$' prefix.



SQL> show user
USER is "SYSTEM"

SQL> show parameter os_authent_prefix

NAME TYPE VALUE
------------------- ----------- ---------
os_authent_prefix string


SQL> create user "yourDOMAINNAME\yourUSERNAME" identified externally default tablespace USERS temporary tablespace TEMP account unlock;

SQL> grant connect, resource, create view, unlimited tablespace to "yourDOMAINNAME\yourUSERNAME";

SQL> commit;



【其它相关参考】

1. Make Oracle database authentication connections using EZCONNECT syntax
2. How to make Oracle database authentication connections using a Net Service Name
3. How to make Oracle external authentication connections (OSA for Oracle) using EZCONNECT syntax
4. How to make Oracle external authentication connections (OSA for Oracle) using a Net Service Name

【创建及修改时间】
Created: 4/7/2014

Last Modified: 4/18/2014
【原文链接】
http://support.esri.com/en/kno ... 42398