Does SHOWPLAN permission allow users to view plans by other users?

Question

As the title says, I am trying to figure out if the SHOWPLAN database level permission will grant an user permission to view plans and queries by other users in the database?

I am little confused from what I have read in the Microsoft documentation. Would appreciate any insight on this

Thanks in advance

Answer 1

The SHOWPLAN permission enables a user to view the execution plan for their own queries.

To view plans and queries from other users (IE view the plan cache via sys.dm_exec_cached_plans) they will need VIEW SERVER STATE permission which is a different permission entirely

MS Documentation