|
|
 | | From: | topgun58 | | Subject: | Connection to SQL Server | | Date: | Sun, 16 Jan 2005 12:06:29 -0500 |
|
|
 | I have a sql server and a database named OVERTIME
In one of the tables I have the fields
OvertimeID, EmployeeID, Date, Hours, User, RecordDate
I have created an ASP web site where a user can log into this server and
authenticate. The web site uses a global.asa file that uses a sql account to
open a connection. For each record that the user inputs In the USER field I
would like to have the name of the person who actually logins and opens a
connection instead of the account in the global.asa file.
How can I fix this problem?
I hope I was able to explain this clearly.
Many thanks
Bill H.
|
|
| | From: | Jim Kennedy | | Subject: | Re: Connection to SQL Server | | Date: | Sun, 16 Jan 2005 09:51:53 -0800 |
|
|
|
"topgun58" wrote in message
news:5uSdnQ7fzfGpAnfcRVn-vA@rogers.com...
> I have a sql server and a database named OVERTIME
>
> In one of the tables I have the fields
>
> OvertimeID, EmployeeID, Date, Hours, User, RecordDate
>
> I have created an ASP web site where a user can log into this server and
> authenticate. The web site uses a global.asa file that uses a sql account
to
> open a connection. For each record that the user inputs In the USER field
I
> would like to have the name of the person who actually logins and opens a
> connection instead of the account in the global.asa file.
> How can I fix this problem?
>
> I hope I was able to explain this clearly.
>
> Many thanks
>
> Bill H.
>
>
You would have to change how they connect. They would have to connect as
themselves not as a global account.
Jim
|
|
|
