Create an Oracle External Authentication user

Summary

Instructions provided describe how to create an Oracle External Authentication user for making operating system authentication connections. For more information, see the Knowledge Base article: How To: Configure the Oracle Instant Client to make Database Authentication and Operating System Authentication connections using ArcGIS Desktop.

Procedure

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;