george sibbald (10/11/2010)
what you have described will work. seehttp://msdn.microsoft.com/en-us/library/ms188754(v=SQL.100).aspx
I am confident it will work. I was just hoping there was a pre-existing list of what DMVs a user was granted perms too when given VIEW SERVER STATE. Then i can work backwards and make sure I DENY SELECT on the appropriate objects.
I want to avoid having to do this (determining the perm difference between VIEW SERVER STATE and not) manually if i can.