I would like to make use of Active Directory Groups for Row-Level Security.
In order to do so I need a functionality to know to which group a login belongs to:
1) a user logs in using AD. The user belongs to a specific group.
2) I can use xp_logininfo to know which group that login belongs to
3) i can use the group within a mapping table for RowLevel Security
4) the user can see only the rows allowed to the group he belongs to