Re: Calling Reports2.5 from Forms4.5 as a different user

From: Adam Tadjkarimi <adamt_at_hsltd.com>
Date: Tue, 9 Feb 1999 18:07:22 -0600
Message-ID: <79qid2$8r1$1_at_newsin-1.starnet.net>



A quick solution which comes to my mind: - If you have developed a pre-report parameter form, add DESUSERID (for userid/password) to the parameter list or CMDFILE or whatever ... - If not, you may wanna create a small form to prmpt the user for the userid and password.
- In the trigger which calls RUN_PRODUCT, verify these values have been entered.
- Pass them to reports along other input parameters. Of course, as I mentioned I've not put much thought to it and there could be better solutions. Hope it helps.

Adam Tadj
Adamt_at_hsltd.com

Opinions expressed or questions asked are mine not of my employer.

eric_peterson_at_maurices.inrg.com wrote in message <79n60k$8mr$1_at_nnrp1.dejanews.com>...
>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
>Database. We do not want to grant execute any procedure access to all
users.
> 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?
>i.e. I log into Forms as User X then call a report and automatically login
as
>User Y(for the Report login only) and would still keep my connection as
User
>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
>
Received on Wed Feb 10 1999 - 01:07:22 CET

Original text of this message