title: How does the SQL Server deal with the discrepancy between role's permission and user's permission
body: <p>If user A has a higher permission than the role's permission which he/she belongs to, which permission will SQL Server takes?</p>