Blog Post

Azure SQL Blog
5 MIN READ

Server roles for Azure SQL Database: Database Management without admin-access

AndreasWolter's avatar
AndreasWolter
Icon for Microsoft rankMicrosoft
Sep 02, 2021
Server roles for Azure SQL Database: Database Management without admin-access   Until now, in Azure SQL Database, to gain access to server-wide information like system-wide wait-stats, resource s...
Updated Sep 03, 2021
Version 5.0
azure sql database
Azure SQL Security
AndreasWolter's avatar
AndreasWolter
Icon for Microsoft rankMicrosoft
Sep 03, 2021

Hi Johannes_Vink 
Since you cannot have an AAD Login, it must be something else.
From which database are you running sys.fn_my_permissions and with which parameter?
In the article's screenshots the member is a SQL Login with an User Account in a User database from where I ran the function.
regards

Andreas