Have a look at the ON_LOGON trigger - or whatever it's called.
"Timbo" <tjbacs_nospam_at_attbi.com> wrote in message
news:3DDA81A5.3060508_at_attbi.com...
> Hi,
>
> Can anyone direct to me to information concerning how to make oracle
> Forms utilize a specific username/password to connect to the
> database? Using 9iR2 database and app server.
>
> Right now our configuration uses a default username and password
> set in formsweb.cfg How can I override that in a form?
>
> Here is what I want to do:
>
> First form opened is a login form. This form can use a 'generic'
> username/pass to connect to the db. I will validate the username and
> password entered into the form off a 'users'
> table in the database. Then I will gather specific information
> about the user and forward them on to another form as appropriate.
> For that form I want to use a username/password specific to that
> user.
>
> How do I do that? I would also like to NOT have that info show in
> the URL.
>
> Thanks.
>
> Tim
>
Received on Wed Nov 20 2002 - 03:49:42 CST
