showplan

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  August 24, 2007 at 8:33 am

  #120183

  can anyone please let me know what privileges are needed to run set showplan on . i have  a user with read/write access but when running this statement it say access denied. Any help will be greatly apprecitaed.

  TIA

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  August 24, 2007 at 9:00 am

  #729304

  Have you tried the GRANT SHOWPLAN database permission?

  GRANT SHOWPLAN TO someuser;

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software