• demin99 (4/24/2015)


    Hi All,Iam able to view showplan when Iam using dbo schema but when I use userdefined schema then I

    get 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

    😎