I created a new Azure SQL DB. It added the server "Admin" account I created to the SQL Server Security>Logins section of SSMS. How can I tell what permissions were assigned to that account? (I presume it's "sa" equivalent but am not sure. I just verified this account has access to all DBs in the Azure SQL DB but is not listed under any database's Security >Users group)

TIA,

edm2

• Edited by edm2 2 hours 56 minutes ago

Hi,

Try using below link to see user permission

http://sanderstechnology.com/2013/login-and-user-management-in-sql-azure/12826/#.VdV2pHnosdU

You can also try the below sql query .

select permission_name, state_desc, type_desc, U.name, OBJECT_NAME(major_id) 
from sys.database_permissions P 
JOIN sys.tables T ON P.major_id = T.object_id 
JOIN sysusers U ON U.uid = P.grantee_principal_id

Thanks
Abhishek