November 21, 2015 at 7:30 am
Hi
It was needed to grant access to some view 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 , I 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
November 21, 2015 at 9:48 am
One approach you could use is to write a procedure to query the system view you want and return the data. When you create it, do it WITH EXECUTE AS OWNER. The procedure will then execute with those permissions. Then, grant execute on the procedure to the user you want to be able to run it.
This is an approach I've used frequently to let people run a procedure that does things they don't have permission to do and it works great.
November 21, 2015 at 11:10 pm
Thank you
😛
November 22, 2015 at 1:26 pm
MotivateMan1394 (11/21/2015)
Thank you😛
No problem. Glad to help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply