January 30, 2005 at 11:00 pm
Hi,
We have to develop a web application which uses Windows Authentication security. So the User Master security table contains Windows User Name and associated system defined security rights.Application Authentication model is Single Signon.
How can we capture the login information of the user whenever he accesses the web application so that validation is possible with User security values in the table?
Thanks
JP
February 1, 2005 at 7:07 pm
If you are trying to determine within the web application and it is written in Active Server Pages, you can use the Request.ServerVariables("Auth_user") to get the user account.
In SQL, SUSER_SNAME is supposed to give you the login name, but I couldn't get it to work on my home system.
If each user's login is mapped to the same user in the database, you could use USER_NAME.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
February 1, 2005 at 7:21 pm
Just happened to see a better answer in another thread: System_User
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply