Our installation plans on disabling passthru access due to the fact that all security checking is being handled via Peoplesoft thru the adapter.

I find this to be extremely crippling. Does anyone know if there is a way for Passthru to be enabled for a subset of users, or if it can be configured to somehow invoke Peoplesoft security the way standard Focus commands do?

Hi TGT,

Is this issue regarding SQL passthru resolved?

I ran a quick search of Focal Point posts and Tech Support documents and came across the following topics which may be of interest:

SQL passthrough username problem
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/
6251097331/r/6251097331

database connection problem
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/
1781087331/r/1781087331

SQL passthru problem with 525
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/
3421087331/r/3421087331

How to secure SQL passthru queries?http://techsupport.informationbuilders.com/sps/82591020.html

In addition, you may want to take a look at the WebFOCUS technique page at
http://techsupport.informationbuilders.com/tech/contents/wbf_toc.html, especially the FAQs, Technical Memos, Techniques/Code Examples, and Security sections.

You will need to log on to the Tech Support website to access those pages.

If you still have questions after reviewing these pages, then the issue may be complicated enough and my next suggestion would be to contact Information Builder's Technical Support Help Desk. You can either call Technical Support Help Desk at 1-800-736-6130, or access the online system InfoResponse at http://techsupport.informationbuilders.com.

Hope this helps.

Cheers,

Kerry

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