Grant View Server State

[Weltchy]

As per http://www.sommarskog.se/grantperm.html#Certificates, you can sign a stored procedure to provide chained ownership within your own database.

However, the VIEW SERVER STATE permission must be granted on the master database. As previously stated, I only spent about 5 minutes on this trying to get it to work, but I'm a bit busy on another project to spare the time. When I've got a bit more spare time, I'll have a deeper look, however, I was curious to know if anyone else had stumbled across this problem and knew of any potential pitfalls.

[DimPrawn]

Attach the user to what? A login?

[Weltchy]

Any one tried to attach, using a signed stored procedure in SQL Server 2008, a certificated user with the GRANT VIEW SERVER STATE permission.

ie, does anyone know how to do this?

[DimPrawn]

Is there actually a question in this post?

[Weltchy]

Any one tried to attach, using a signed stored procedure in SQL Server 2008, a certificated user with the GRANT VIEW SERVER STATE permission. I had a hack around for 5 minutes to try to get this to work, but didn't succeed.

I've temporarily granted the actual user the VIEW SERVER STATE permission, but going forward, the best solution would be to go down the signed stored procedure route.