How do you set the database user role when you log in to the datasource in Tibco Data Virtualization?
Article ID: KB0082271
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.6 |
Description
How do you set the database user role when you log in to the datasource in Tibco Data Virtualization?
Issue/Introduction
This document describes where to configure the database user role when you connect to a datasource registered in the Tibco Data Virtualization (TDV).
Resolution
There are two ways you can set the roles for the datasource user when you connect to a CIS datasource:
- Database is the preferred method and is performed by the Database Administrator (DBA) of the datasource and is configured externally from TDV.
- Specify a connection check-out procedure where the role is set within the procedure with the use of Structured Query Language (SQL) similar to this example:
Feedback
Yes
No
Powered by
