What Roles give SHOWPLAN permission?

Question

With certain server level or database level roles, you have SHOWPLAN permission. Is there a hierarchy list that would indicate all the permissions inherited by various roles?

I'm thinking of assigning ##MS_ServerStateReader## to our developer Login on the Production server and I'm hoping that as well as all those useful DMVs, the associated users will be able to request an actual execution plan.

At present that kind of access is given by adding the role DB_Owner which gives way more rights than is required for these users.

If not that server level role, is there any other that gives those permissions or do I need to set up a user-defined role?

Answer 1

See SET SHOWPLAN_ALL (Transact-SQL) => Permissions