Get Windows Logged In Username In SQL When Using Win Auth Mode In SQL Form ASP

Hi Guys,

I have an Intranet web application and I have to use windows authentication. They are 4 main users group to access the application, each with different set of permission on my store procedures.

I have created a windows group for each of those group in my windows environemnt. My DB Connection String in web.config is set to Integrated Windows Authentication ( Integrated Security=SSPI)

I have done all configuration based on this article: http://msdn2.microsoft.com/en-us/library/ms998292.aspx

I have 4 different database Roles in my database and 4 different database users. I also add NT AUTHORITYNETWORK SERVICE as a member of each of those database Roles.

Now I get connected, fine and set permission on the database roles.

1 thing I want to know, How Can I get the Windows Group name in the database, which has the same name as my SQL Login and Database Roles or User

I tried all SUSER_SNAME() and ... they all return NT AUTHORITYNETWORK SERVICE

I want to get AppPowerUser Role or windows group name. I think I should be able to because I am using windows authentication.

Any help is appreciated.

Mehdi