September 7, 2021 at 4:26 pm
What is a rightest way to grant such permissions to a non-admin user?
User belongs to a group that has certain limited permissions on the server, with access to only several user databases.
The user however needs to query DMVs in Master DB. Is it doable? and what is a good way to do it?
thanks.
Likes to play Chess
September 7, 2021 at 4:41 pm
Other than VIEW SERVER STATE, i mean..
Likes to play Chess
September 8, 2021 at 12:09 pm
I'd say you either have to use VIEW SERVER STATE and/or VIEW DATABASE STATE, or you need to create your own custom views/procedures and then give them access through there. The documentation is pretty concise & clear on this one.
"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
September 8, 2021 at 4:00 pm
look at
and
https://sqlrambling.net/2018/04/24/using-a-certificate-to-sign-a-stored-procedure/
one way of allowing particular functions to work while not granting the permissions directly.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply