SqlException: EXECUTE permission denied on object

• gobalistik

  Grasshopper

  Points: 13

  More actions

  August 3, 2002 at 12:02 pm

  #64129

  When trying to run a stored procedure from a web form i get the following error SqlException: EXECUTE permission denied on object.

  HELP!!!!!

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 3, 2002 at 12:19 pm

  #433951

  You need to grant execute permissions to the procedure, for the user/login you're using to connect to the database.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter