Restrict the read only role to only the "Overview" page.
I've explored using Read Only views for SQL Monitor and they work great, while really parring down the amount of information that the user can see. However, is there are way to lock it down even further so that they can only see the homescreen with the colored status on the specified SQL Instances? Essentially only allowing them to see status without drilling down into the instance itself and viewing waits, disk, CPU etc.
This could be used by management, etc.
5
votes
Dexter Johnson
shared this idea