How do I see roles assigned to a user in Windows?
In Service Manager, when you click Administration, expand Security, and then click User Roles, a User Roles pane displays a list of user roles.
What is a role in application?
An application role is a database principal that enables an application to run with its own, user-like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application.