question

Sharma avatar image
Sharma asked

How to check login group of any member?

As I know we can check the members of any login group through command 'xp_logininfo 'mssql\SQL 2005', 'members'' similarly am looking command to find out login group for any member. Example:Domain user 'mssql\test' that is related to Domain Group 'mssql\SQL 2005', SQL server have so many login group available so it is time taking to check member for all group and find related group for member so looking any command to find related group of member. Solution could be on SQL command or OS command.
loginwindows-2003user-group
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
I am not sure what you are after, but should not the use of account_name and 'all' option gives the desired result? EXEC xp_logininfo 'FullyQualifiedName', 'all' From BOL > If **account_name** and **all** are specified, all permission paths for the Windows user or group are returned. If account_name is a member of multiple groups, all of which have been granted access to SQL Server, multiple rows are returned
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sharma avatar image Sharma commented ·
Thanks, It is giving desired results.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.