In the case of the admin user, pass-through credentials specified by setDataSourceCredentials() are not used

In the case of the admin user, pass-through credentials specified by setDataSourceCredentials() are not used

book

Article ID: KB0080591

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization v7.0.0 and higher

Description

In the case of the admin user, pass-through credentials specified by setDataSourceCredentials() are not used.

Issue/Introduction

In the case of the admin user, pass-through credentials specified by setDataSourceCredentials() are not used

Resolution

The admin user is an exception to setDataSourceCredentials(), as the user is intended for TDV administration. If a TDV client logs in to TDV as the admin user, the data source credentials will be used to connect to the back-end database server (instead of passing through the credentials specified by setDataSourceCredentials()).

For example, consider the following scenario:

(1) A data source is configured to use annette as the login name.

(2) A JDBC client logs in to TDV as admin.

(3) After logging in to TDV, the JDBC client proceeds to set pass-through credentials on the data source using the name bobby, as shown below.

((cs.jdbc.driver.CompositeConnection)conn).clearAllDataSourceCredentials();
((cs.jdbc.driver.CompositeConnection)conn).setDataSourceCredentials("/shared/my_data_sources/Oracleds", "bobby", "password");

The data source will not connect to the database server as bobby. Instead, it will connect as annette.