O
Onur Gorur
I have an asp.net web application that executes stored procedures on SQL
Server 2000 on the backend and displays the results of this stored procs on a
grid. I use integrated windows authentication on IIS, asp.net and SQL Server.
Here is what I want to do:
- When a user starts to use the application I want to get the credentials of
the user. (This can be done by web.config:: <identity impersonate="true">)
- After I get the user info, I would like to run the stored procedures with
a different specific NT user's credentials, one that I will give all SQL
Server accesses. So, I will not give any application user SQL Server direct
query access but only this specific user account. (This can be done by
impersonating this specific user in the web.config)
I want both of this, but I could not find a way to accomplish both. One
method I thought would be having one asp.net application and another web
service application both running with different credentials: First, with the
logged in user and second with my sql server account)
Any other ideas? Help wanted!
Thanks in advance
Server 2000 on the backend and displays the results of this stored procs on a
grid. I use integrated windows authentication on IIS, asp.net and SQL Server.
Here is what I want to do:
- When a user starts to use the application I want to get the credentials of
the user. (This can be done by web.config:: <identity impersonate="true">)
- After I get the user info, I would like to run the stored procedures with
a different specific NT user's credentials, one that I will give all SQL
Server accesses. So, I will not give any application user SQL Server direct
query access but only this specific user account. (This can be done by
impersonating this specific user in the web.config)
I want both of this, but I could not find a way to accomplish both. One
method I thought would be having one asp.net application and another web
service application both running with different credentials: First, with the
logged in user and second with my sql server account)
Any other ideas? Help wanted!
Thanks in advance