Calling Reports2.5 from Forms4.5 as a different user
Date: Mon, 08 Feb 1999 17:14:05 GMT
Message-ID: <79n60k$8mr$1_at_nnrp1.dejanews.com>
[Quoted] We're in the process of installing a 3rd party software package. The front end is done in Forms4.5 and the backend is Oracle 7.3.3 DB. This package contains stored procedures, functions and packages. The front end also contains some .pll's. The front end has quite a few reports embedded throughout the application. When a report is run, it eventually calls a procedure in a .pll to make a call to RUN_PRODUCT. Also when a report is run, stored procedures are called that just query information. The procedures that are called are intertwined with ones that make updates to the [Quoted] Database. We do not want to grant execute any procedure access to all users. [Quoted] For security reasons and data integrity, everyone has non-default roles. This prevents a user from changing data using programs like MS Access or Excel.
Does anyone have a solution such that I may call Reports2.5 as a different userid/password than I would have for logging into the third party software? [Quoted] i.e. I log into Forms as User X then call a report and automatically login as [Quoted] User Y(for the Report login only) and would still keep my connection as User [Quoted] X. I have already tried passing a parameter list with a different userid/password to RUN_PRODUCT and it seems to be ignoring it.
Thank you in advance and have a great day!
Tx
Eric Peterson
Programmer/Analyst DBA
Maurices Inc.
eric_peterson_at_maurices.inrg.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 08 1999 - 18:14:05 CET