Let's say I'm a user in windows domain DC (DataCenter).
My user-name is DC\Somebody
I'm in group DC\Developers
Now SQL-Server has the login group called DC\Developers, and with that, I can login on the server with integrated security.
I'm now trying to get the SQL-Server login (by which I mean DC\Developers), but I can't figure out how. All I can get is the username (DC\Somebody).
But I want to get DC\Developers.
How can I do that ?
This are the functions I tried so far, without success:
SELECT -- http://blog.sqlconcepts.co.nz/2011/07/who-am-i.html ORIGINAL_LOGIN() AS OriginalLogin ,SUSER_SNAME() AS CurrentContext ,SESSION_USER AS SessionUser ,SYSTEM_USER AS SystemUser ,CURRENT_USER AS CurrentUser ,user AS "WhichUserIsThat?" ,ORIGINAL_LOGIN() AS OriginalLogin ,USER_NAME() AS UserName
Also, what happens if multiple groups are added as sql-server logins, and I'm a member of them all, and then I login with integrated security. Which login will it take ? It appears to be the alphabetically first ...