Getting NTFS Group membership

[vicoluf]

Hi,
Permissions were granted to sql users based on their groups in the domain - that is groups were added as sql users rather than the login names.
Is there any way I can determine the group a user belongs on login to sql server?. I need to develop an interface that enables relevant menu to relevant groups.

Thanks,

Victor

[Rawhide]

Try "Select SUSER_SNAME()"

[vicoluf]

Thanks for your reply.
What I meant is that after extracting login name from SELECT SYSTEM_USER I need to determine to which NT group the user belongs .....

Victor

[MAK]

you have to query Active Directory.

[rmiao]

And you can't get windows group membership for standard sql logins.

[vicoluf]

Thank you all for your replies