SQL_Hunt
SSC-Dedicated
Points: 33518
More actions
November 13, 2017 at 2:02 pm
#326258
Hi
Can having DBO permission at the database level will allow the users to get the execution plan so that they can do some initial understanding of the queries being run? Or do they need any higher order of priviliges?
Thanks.
Chris Harshman
SSC-Forever
Points: 42192
November 13, 2017 at 2:54 pm
#1967877
If all you want to do is allow users to see execution plan, it's probably preferable to just do a GRANT SHOWPLAN:https://technet.microsoft.com/en-us/library/ms189602(v=sql.105).aspxDB_Owner would probably be overkill for regular users, and would allow them to do many things they shouldn't do:https://www.mssqltips.com/sqlservertip/1900/understanding-sql-server-fixed-database-roles/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply