English

How To: Create an Oracle External Authentication user

Summary

Instructions provided describe how to create an Oracle External Authentication user for making operating system authentication connections. See Knowledge Base article 42269 for more information.

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;

Related Information