Hi
It was needed to grant access to a user in some views that I created them from system views. For example : Blocked Processes
But When I grant access Select To this view from "securables" and grant access to 3 views to user , It didnt work .
I Had to Mixed this access with : "Grant VIEW SERVER STATE to User"
But
After That user can Select To All Sql server system Views. It is very Dengerous And I want to limit it.
Please Help me ?
Thank you