MS SQL 2005/2008: Identify current user
Posted
by Torben H.
on Stack Overflow
See other posts from Stack Overflow
or by Torben H.
Published on 2010-04-09T06:37:34Z
Indexed on
2010/04/09
6:43 UTC
Read the original article
Hit count: 411
t-sql
|sql-server-2005
Hello
I have a web application, which is using a MS SQL 2005 database.
My problem is, that the application has no rolemanagement. So the application always accesses the database with one default user. But now I have to save and access a value only for the current user.
Is there any way to do this? Maybe something like a session on the webserver? The best way would be, if there is any possibility to access the current session id of the webserver from T-SQL.
Do anyone understand my problem? :)
Torben
© Stack Overflow or respective owner
