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?
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:
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).
Feedback
Yes
No
Powered by
