2

Query store is enabled on 2 of our production databases but I no longer have access to see the Query Store node under the database since my SA privileges were revoked (I had them temporarily for a new server).

I can't find anywhere that describes what minimum permissions are needed for access to query store reports.

  • Does this help? – Erik Darling Nov 16 '17 at 21:31
  • Yes, that's the ticket ;-) – Saxman Nov 21 '17 at 20:21
  • @ErikDarling The link is broken. Could you please post the author name and article name? – Lijo Feb 11 at 21:18
4

Just use

GRANT VIEW DATABASE STATE TO [USER];

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.