July 30, 2014 at 6:58 am
What will VIEW SERVER STATE permission do? will it have the permission to restart the sql server?
July 30, 2014 at 7:04 am
No, it wont. It allows acces to a range of system catalogs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 8:15 am
Pretty sure the key word there is VIEW, but we could also add STATE. Same thing with VIEW DATABASE STATE.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2014 at 8:34 am
Grant Fritchey (7/30/2014)
Pretty sure the key word there is VIEW, but we could also add STATE. Same thing with VIEW DATABASE STATE.
😀 clearly those terms are confusing!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply