demin99 (4/24/2015)
Hi All,Iam able to view showplan when Iam using dbo schema but when I use userdefined schema then Iget an error SHOW PLAN denied on database.
select * from dbo.table (Iam able to view show plan)
select * from user.table (Not able to view show plan)
Need your help to resolve this.
Thanks,
Demin
Don't think this has changed since 2008, you'll have to be at least db_owner (dbo), check it here: Showplan Security
😎