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     SQLPASSTHRU: Setting user id and pw

Read-Only Read-Only Topic
Go
Search
Notify
Tools
SQLPASSTHRU: Setting user id and pw
 Login/Join
 
<Radha>
posted
While using SQLPASSTHRU, is it possible to set connection attributes: USER id and pw different from those used while configuring the data adapter?
While configuring the data adapter explicit is selected and user is mentioned as user1, but in a particular scenario, I need to insert some data into a table and only user2 has the required Privileges. Is it possible to override using:
ENGINE SQLORA SET CONNECTION_ATTRIBUTES db1/user2,pw2 OR
SQL SQLORA SET USER user2,pw2?
I tried doing this but it dint work. Is there any other alternative ?
Thanks in Advance
 
Report This Post
GinnyJakes
Expert
posted Hide Post
You should be able to do it by putting the connection string in your focexec. You might also have to use the ENGINE SQLORA SET DEFAULT_CONNECTION connect_source; command as well.

And what do you mean that it didn't work? Could you be a little more specific?


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
<Radha>
posted
Thank you, that helped.
I meant, after setting the connection attribute, when I tried executing the query, SELECT USER FROM DUAL it still shows me the User ID set while configuring the data adapter.
 
Report This Post
GinnyJakes
Expert
posted Hide Post
I don't understand why this isn't working. We don't do it a lot for Oracle but we do override the default connection for Teradata and DB2 all the time.

Please verify your connection attributes statement. Ours look like this:

ENGINE SQLORA SET CONNECTION_ATTRIBUTES db1 db1/user1,939A3B359C657700


Followed by 

ENGINE SQLORA SET DEFAULT_CONNECTION db1;


If this doesn't work for you, then I recommend that you open a case with IBI.


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     SQLPASSTHRU: Setting user id and pw

Copyright © 1996-2020 Information Builders