Re: Obtaining user name and password in forms 3.0

If you are using Oracle*Forms 4.5,
you can get username and password, connect_string etc. using

    GET_APPLICATION_PROPERTY built-in.

Hope this will help you.I have used it.

Rasjid Arifin wrote:
>
> 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:
> * 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 Mon Feb 10 1997 - 00:00:00 CET