List All Users' Server Permissions

Question

How do you get a list of all users' server permissions without using impersonation? This doesn't include all server permissions i.e. create database.

USE [master]
SELECT pr.principal_id, 
       pr.name, pr.type_desc,   
       pe.state_desc, 
       pe.permission_name   
FROM sys.server_principals AS pr   
JOIN sys.server_permissions AS pe 
    ON pe.grantee_principal_id = pr.principal_id

Answer 1

Hi Pat
Azure SQL Database as a PaaS service does not expose the Server-Level permissions that you would expect to see in the boxed product.
There are some specific permissions/roles that exist as documented here. Note that the master database in Azure SQL Database is more of a logical concept because of the PaaS nature of the databases.