SQLTeam.com | Weblogs | Forums

Limit Access to system views


#1

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


#2

Put them on the public role, and only give SELECT permission to the tables/views you want.

You can't stop them from seeing the system views but you can stop them viewing what those views return.
Note - If they don't have permission on the table, sys.tables will not return that table.