Microsoft SQL server 2016
Microsoft Windows 2019
How do i see what roles a user is member of? The roles show what kind of user access he gets in the database.
In SQL management studio, enter this query, to find roles the user is part of;
exec xp_logininfo 'DOMAIN\username', 'all'
In powershell you can enter this command to find content of groups
Get-ADGroupMember -Identity adgroupname | select name, objectclass
Or also expand to find users in groups
Get-ADGroupMember -Identity adgroupname -Recursive| select name, samaccountname