Permissions in Azure SQL DB

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 Thursday, August 20, 2015 4:12 AM
August 20th, 2015 4:06am

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

  • Marked as answer by edm2 Thursday, August 20, 2015 8:34 PM
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 6:44am

Yes, the server admin login you created when creating the database is analogous to the 'sa' account for SQL Server. See Managing Databases, Logins, and Users in Azure SQL Database on MSDN for details. This login has full permissions to manage all server- and database-level security.

Note that the query posted by Abhishek will only list permissions that have been explicitly granted to principals, so you won't see any permissions for the server admin login listed there. See the documentation for sys.database_permissions for details.


  • Marked as answer by edm2 Thursday, August 20, 2015 8:34 PM
August 20th, 2015 3:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics