Connecting to the Oracle Database Using Windows Authentication
The Microsoft BizTalk Adapter for Oracle Database enables adapter clients to use Windows Authentication to establish a connection with the Oracle database. To use Windows Authentication, the adapter clients must specify “/” for user name and leave the password blank. For more information about connecting to the Oracle database using Windows Authentication, see Connecting to the Oracle Database in Visual Studio Using Consume Adapter Service Add-in.
To enable adapter clients to use Windows Authentication to connect to an Oracle database, you must perform the following tasks on the computer running the Oracle database.
- Make sure that the
sqlnet.orafile on both the client and the server, available under
ORACLE_BASE\ORACLE_HOME\network\admin\sqlnet.ora, has the following entry:
- Connect to the Oracle database as SYSDBA.
- Create the Windows user as an external user in the Oracle database. Note that the user name must be in upper case.
CREATE USER “OPS$<DOMAIN_NAME>\<USER_NAME>” IDENTIFIED EXTERNALLY;
- Grant privileges to the user.
GRANT CONNECT,RESOURCE TO “OPS$<DOMAIN_NAME>\<USER_NAME>”;
- To enable the newly created user, logging in using Windows Authentication, to access the Oracle database artifacts, you can change the user’s schema to the SCOTT schema. You can add the following SQL command to the logon script that changes the user’s default schema to SCOTT when the user logs on.
alter session set current_schema=SCOTT;
- Even though you changed the schema of the user to the SCOTT schema, you will still not be able to see the Oracle database artifacts while browsing and generating metadata using the Oracle Database adapter. This is because the newly created user does not have permissions for the SCOTT schema. Make sure you provided permission for the SCOTT schema to the newly created user.