isakhnov (4/3/2010)

---

How can I retrieve the SID of the login?
...
SUSER_SID retrieves my windows account SID
...
I do not see a way to retrieve a SID for the login itself.

isakhnov (4/3/2010)

---

SUSER_SID returns the SID of test\userA and I'm looking at ways to retrieve the SIF matching the specified on a server login (test\groupB)

SELECT  SUSER_ID(N'test\userA');
SELECT  SUSER_ID(N'test\groupB');

SELECT  sid
FROM    sys.server_principals
WHERE   name IN (N'test\userA', N'test\groupB');

Paul White NZ (4/3/2010)

---

From Books Online: "'login' is the login name of the user. login is sysname. login, which is optional, can be a Microsoft SQL Server login or Microsoft Windows user or group. If login is not specified, information about the current security context is returned."

What does the following give you?

SELECT  SUSER_ID(N'test\userA'); -> sid of the windows user
SELECT  SUSER_ID(N'test\groupB'); -> sid of the windows group

SELECT  sid
FROM    sys.server_principals
WHERE   name IN (N'test\userA', N'test\groupB'); -> sid of the windows group only

isakhnov (4/5/2010)

---

I see. I can use xp_logininfo to get to the login used for the session, thanks!
Do you know how bad is the performance? Original implementation was retrieving this info from the sys.login_token but we had to drop it due to the terrible performance.