Grant Showplan error

• demin99

  SSC Eights!

  Points: 927

  More actions

  April 24, 2015 at 11:14 pm

  #317651

  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

• Eirikur Eiriksson

  SSC Guru

  Points: 182882

  More actions

  April 24, 2015 at 11:54 pm

  #1793454

  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

  😎