Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Setting database client identifier before retrieving records

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Setting database client identifier before retrieving records
 Login/Join
 
Padma
Member
posted
We have a requirement to show the report contents based on user id. We are using Oracle 10g VPD policies to apply data authorization. We are using SiteMinder for authenticating users into Webfocus environment. We retrieve login user id from the SiteMinder header variable and set the client identifier before the report is generated.(exec dbms_session.set_client_identifier('userid')Wink This works perfectly within our FEX file. I need to apply the same logic to display drop down boxes in HTML files(we populate drop down boxes with column values from a database table)
I have attached FEX sample code which displays data based on userid

SQL SQLORA
-MRNOEDIT EX SET_DB_CONTEXT '&REMOTE_USER';
TABLE FILE SQLOUT
END
TABLE FILE fund_master
PRINT *
END

This message has been edited. Last edited by: Kerry,


Webfocus: 7.1.7/ OS: AIX Platform: Websphere
 
Posts: 5 | Location: Boston | Registered: June 25, 2008Report This Post
dhagen
Virtuoso
posted Hide Post
You should include the context setting in the _site_profile. The _site_profile allows you to include a FEX that will be executed whenever a WF request is executed. You can get to the site profile setting in the client admin console under "Configuration/General".


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Kerry
Expert
posted Hide Post
FYI, Padma has not tried the option suggested yet and will take few more days to post the update. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Padma
Member
posted Hide Post
Thank you for the suggestion. We made changes in our site profile to include the common fex. I also verified that common fex is called before HTML file is loaded but the result is not as expected. Basically we are trying to restrict of list of values shown in drop down box based on login user id. For example, if fund_master table has following records 001, 002,003,004,005, when user A runs the HTML report, user A should be able to see only 001, 002, 003 values from the drop down. When user B runs the same report, user B should be able to see only 001, 002, 003, 004 values.
We are using MAS (webfocus synonym) to populate the drop down boxes. I am assuming webfocus synonym uses default user configured in the data adapter. In our case the adapter is configured with application user(RPTUSER). Next step I want to try is, to add few records in fund_master table for RPTUSER and see if the drop down shows values as expected.

If anybody has any other suggestions please let us know


Webfocus: 7.1.7/ OS: AIX Platform: Websphere
 
Posts: 5 | Location: Boston | Registered: June 25, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
Have you tried using a procedure with a WHERE clause to populate your dropdown box?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Setting database client identifier before retrieving records

Copyright © 1996-2020 Information Builders