azure sql database – What permission is needed to read sys.dm_db_stats_properties?
Using Azure SQL, I have a procedure signed by certificate in which I’d like to read table statistics. The proc can read sys.stats fine but I get zero rows from a query using sys.dm_db_stats_properties, for example FROM sys.stats S CROSS APPLY sys.dm_db_stats_properties(S.object_id,S.stats_id) SP WHERE S.object_id= 123456.
I have applied the following perms to the user that the cert is linked to…
GRANT VIEW PERFORMANCE DEFINITION TO Maintenance_User
GRANT VIEW DATABASE PERFORMANCE STATE TO Maintenance_User
GRANT VIEW DEFINITION TO Maintenance_User
GRANT VIEW DATABASE STATE TO Maintenance_User
Am I missing another GRANT? Is there a different permission I need to apply?
Read more here: Source link
