Dec 19, 2018 - VIEW SERVER STATE permission was denied on object 'server'. Even though the error above says database 'master', I was running the. Jan 7, 2019 - 'Error 300, Procedure: uspSQL LockRead, Message: VIEW SERVER STATE permission was denied on object 'server', database 'master'.
When I execute the following query: SELECT. FROM sys.dmiovirtualfilestats(NULL, NULL)I get the error:Msg 262, Level 14, State 1, Line 4 VIEW DATABASE STATE permissiondenied in database 'master'. Msg 297, Level 16, State 1, Line 4 Theuser does not have permission to perform this action.But I able to execute this query using the provisioned (by SQL Azure portal) administrator user.I am unable to GRANT VIEW DATABASE STATE for master (using the provisioned administrator user) to any of the user I created, I get the following error:Grantor does not have GRANT permission.Any ideas how to be able to execute the query SELECT. FROM sys.dmiovirtualfilestats(NULL, NULL)from a user other than the provisioned (by SQL Azure portal) administrator user?