title: How to view the roles and permissions granted to any database user in Azure SQL server instance?
body: <p>Could you guide me on how to view the current roles/permissions granted to any database user in Azure SQL Database or in general for a MSSQL Server instance? </p>
  
  <p>I have this below query: </p>
  
  <pre><code>SELECT r.name role_principal_name, m.name AS member_principal_name
  FROM sys.database_role_members rm 
  JOIN sys.database_principals r 
      ON rm.role_principal_id = r.principal_id
  JOIN sys.database_principals m 
      ON rm.member_principal_id = m.principal_id
  WHERE r.name IN ('loginmanager', 'dbmanager');
  </code></pre>
  
  <p>I further need to know what are the permissions granted to these roles "loginmanager" and "dbmanager"? </p>
  
  <p>Could you help me on this?</p>