Re: Obtaining user name and password in forms 3.0

From: Rasjid Arifin <rarifin_at_rad.net.id>
Date: 1997/02/06
Message-ID: <32F94303.2876_at_rad.net.id>#1/1

Steve Elster wrote:
>
> Is there any way to access the current Oracle user name and password
> from within a form? I want to call a report from a forms procedure
> and pass the current username and password to the report so that
> it will use the correct database. None of the system variables seem
> to contain this information. However, when a form calls another
> form, the called form seems to know which database to connect to, so
> this information must be available internally.
>
> Any suggestions gratefully recieved.
>
> Stephen Elster.

What I did in form 3.0 was:
[Quoted] * Create a login form so that we (programmer) can have the login name and user password and stored it into a global variable.   eg: :GLOBAL.GET_USERPASSWORD := :BLOCK_NAME.PASS;   We can use the global vars anywhere, calling another forms/reports. * Ask your DBA about automatic login
  Users can run a report for example in dos environment with Novell ORACLE RDBMS:

     runrep report_file /    ---> means that use current user name and
password to run                                    this report and

connect to default database.
  You must set your variables such as: Local database, remote database, ora_spx etc.
  You can't use automatic login with local database (PC ENVIRONMENT) in rdbms 6.0 for dos.

I hope this will help you..

---

Rasjid Arifin                mailto:rarifin_at_rad.net.id         

Jakarta - INDONESIA Received on Thu Feb 06 1997 - 00:00:00 CET