Oracle validation through ASP

Hi,

My requirement is for the user to be able to view/update the DB via an
ASP application.To save him from remembering too many passwds, I want
to be able to authenticate him without creating a separate 'user' table
with another passwd et al in the DB.Can I have a login page where he
supplies his already existing oracle userID and passwd and then can I
use these as parameters in the connection string? I am using ASP and
Oracle 9i - has anyone tried this and what does the code look like?

Thanks !

Re: Oracle validation through ASP

Hi pnadella,

If the login credentials are supplied, store them in a session variable and
use them in your connection string. Is there a reason that you don't have
one single Oracle login for your web app though, so that the user doesn't
have to enter any login credentials (other than perhaps for the application
itself)?

Ray at work

"pnadella" wrote in message
news:1130421571.495619.226950@g47g2000cwa.googlegroups.com.. .
> Hi,
>
> My requirement is for the user to be able to view/update the DB via an
> ASP application.To save him from remembering too many passwds, I want
> to be able to authenticate him without creating a separate 'user' table
> with another passwd et al in the DB.Can I have a login page where he
> supplies his already existing oracle userID and passwd and then can I
> use these as parameters in the connection string? I am using ASP and
> Oracle 9i - has anyone tried this and what does the code look like?
>
> Thanks !
>

Re: Oracle validation through ASP

Thank you Ray for your response.

The users complained about having a separate web login as they didnt
want to have to remember another passwd.They are OK with having a login
page but they want to be able to login using their existing oracle
userid's and passwd's.Is there a way for the web app to authenticate
the user based on his NT login?And could you please also send me sample
code for building the connection string based on user input parameters?

Thanks !

Ray Costanzo [MVP] wrote:
> Hi pnadella,
>
> If the login credentials are supplied, store them in a session variable and
> use them in your connection string. Is there a reason that you don't have
> one single Oracle login for your web app though, so that the user doesn't
> have to enter any login credentials (other than perhaps for the application
> itself)?
>
> Ray at work
>
> "pnadella" wrote in message
> news:1130421571.495619.226950@g47g2000cwa.googlegroups.com.. .
> > Hi,
> >
> > My requirement is for the user to be able to view/update the DB via an
> > ASP application.To save him from remembering too many passwds, I want
> > to be able to authenticate him without creating a separate 'user' table
> > with another passwd et al in the DB.Can I have a login page where he
> > supplies his already existing oracle userID and passwd and then can I
> > use these as parameters in the connection string? I am using ASP and
> > Oracle 9i - has anyone tried this and what does the code look like?
> >
> > Thanks !
> >

Re: Oracle validation through ASP

Yes, I agree, creating additional logins unnecessarily is no good!

Which part are you stuck on? How to create a form that accepts a username
and password.

What to do with that data?

How to connect to Oracle?

How to tell if the connection was successful?

Ray at work

"pnadella" wrote in message
news:1130432759.170752.124820@g49g2000cwa.googlegroups.com.. .
> Thank you Ray for your response.
>
> The users complained about having a separate web login as they didnt
> want to have to remember another passwd.They are OK with having a login
> page but they want to be able to login using their existing oracle
> userid's and passwd's.Is there a way for the web app to authenticate
> the user based on his NT login?And could you please also send me sample
> code for building the connection string based on user input parameters?
>
> Thanks !
>
> Ray Costanzo [MVP] wrote:
>> Hi pnadella,
>>
>> If the login credential