Re: Is Password Available in SQL*FORMS 3.0 as a variable ?

In article <12299_at_inews.intel.com>, kortikar_at_mipos2.intel.com writes:
|>
|> I want to run runrep by using host(runrep ......) in sql*forms 3.0
|>
|> How do I get the passwd of the current user ?
|>
|> Thanks.
|>
|> Aniruddha Kortikar (kortikar_at_mipos2.intel.com)

You Can't However do one of the following :-

1. call the form from menu. in menu you do thave the current user & password, these can be put into global variables & passed to the form & then into runrep.
2. create a user with select access only to the tables & then run the report as this user (this is what I chose).
3. write a wrapper to forms3 that puts password & username in a file then as you call report use another wrapper to get them out of the file to pass to report.

RICK DIPPER, Unix Systems Administrator                       rick_at_uk.ac.man.cs
Department of Computer Science, University of Manchester           061-275-5725
.............................Meemberrr the of Fumblee Ingers Culb..............