HOW TO

Create an Oracle External Authentication user

Last Published: April 25, 2020

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;

Article ID:000012028

Software:
  • Legacy Products
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options