Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Oracle Connection ClientID=user id
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Oracle Connection ClientID=user id
 Login/Join
 
Member
posted
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
 
Posts: 4 | Registered: September 06, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1569 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 4 | Registered: September 06, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1569 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Oracle Connection ClientID=user id

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.