Powershell sql roles $Users = dir Sqlserver:\sql$Server$Instance\databases$Database\Users foreach ($U in $Users) {"=$U="; $U.EnumRoles()}