SqlException: EXECUTE permission denied on object

• gobalistik

  SSC Rookie

  Points: 33

  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: 119912

  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
  Connect with me on LinkedIn