April 16, 2024 at 4:22 pm
All,
I'm trying to find a way to let some of our users see at least some details of a query plan particularly whether an index is being used.
I looked at the set statistics statements because the user only needs permissions to run the query but they only specify tables and not indexes?
I think the only option would be to give them showplan permissions?
I'm trying to avoid showplan because of the security risks listed detailed here https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/permissions-required-to-run-sql-server-profiler?view=sql-server-2016&redirectedfrom=MSDN
April 16, 2024 at 6:24 pm
Did you check this article . https://techcommunity.microsoft.com/t5/azure-sql-blog/using-query-store-with-least-privileges-instead-of-db-owner-to/ba-p/775177
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 17, 2024 at 10:27 am
Hello,
Thanks for your help. I hadn't seen that and it it looks interesting. I will take a look.
I didn't specify when I created my post but I was more thinking of users seeing the plans for queries they are running at the moment rather than historic analysis.
June 10, 2024 at 6:09 am
You could look at the SSRS functionality to produce the show plan results from data management views. Your users may have their own login to look at the query results ONLY. I think this should work.
DBASupport
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply