Configure credential mapping for a JDBC data source

You can map WebLogic Server user IDs to database user IDs. If credential mapping is enabled on the data source, when an application requests a database connection from the data source, WebLogic Server determines the current WebLogic Server user ID and then sets the mapped database ID as a light-weight client ID on the database connection.

Note:

This feature relies on features in the JDBC driver and DBMS. It is only supported for use with Oracle and DB2 databases and with the Oracle Thin and DB2 UDB JDBC drivers, respectively.

To configure credential mapping for a JDBC data source:

If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
Navigate to the data source that you want to modify:
- Navigate to JDBC data source system resources
- Navigate to JDBC application modules
Select the Configuration: Connection Pool tab.
Scroll down and click Advanced to show the advanced connection pool options.
Select the Enable Credential Mapping check box and then click Save.
Select the Security: Credential Mapping tab.
For each WebLogic Server user ID that you want to map to a database user ID:
1. Click New to open the Credential Mapping Properties page.
2. In WebLogic Server User, enter the WebLogic Server user name that you want to map to a database user ID.
3. In Remote User, enter the database user ID.
4. In Remote Password, enter the password for the database user ID.
5. In Confirm Password, re-enter the password for the database user ID.
6. Click OK.
To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
Not all changes take effect immediately—some require a restart (see Use the Change Center).