Focal Point
[CLOSED] Oracle Connection ClientID=user id

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9227093196

June 28, 2019, 12:00 PM
Terry McBrien
[CLOSED] Oracle Connection ClientID=user id
Does anyone know how to set an Oracle Connection ClientID? WF Version 8.1.05M Oracle adapter. -Thanks

This message has been edited. Last edited by: FP Mod Chuck,


8105M, AIX, Linux, Windows, All Outputs
June 28, 2019, 12:43 PM
FP Mod Chuck
Terry

If the adapter connection is set up with Password Passthru the user ID and Password received fromthe client will be passed to the database. So whatever the user logs into WebFOCUS with must match the oracle user / password combo


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
June 28, 2019, 02:22 PM
Terry McBrien
thanks Chuck. Our connection usage is a little different. Our connection is explicit with a utility id. But in Oracle, a connection has a session attribute called ClientID and the ClientID can be set to a different user id string.
For instance, we want to define a connection "CONN1" connect explicit with tnsnames=DBSIDENTRY, userid=UTILITYID, and hashed password. Then, we need to set CONN1's connection session value for CLIENTID=abc01002.
Just wondering if this possible somehow.


8105M, AIX, Linux, Windows, All Outputs
June 28, 2019, 03:49 PM
FP Mod Chuck
I don’t think that is an option but you should open a case with techsupport to verify


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats