Grant Execute

• Bill Heckle

  Old Hand

  Points: 327

  More actions

  April 16, 2004 at 10:55 am

  #85177

  I am try to issue the following statement;

  GRANT EXECUTE ON mystoredproc TO myrole

  I get an error invalid object; yet mystoredproc is in sysobjects as a procedure and myrole is valid as I grant some selects on tables to it without problem. Any suggestions would be helpful as this problem is making me feel dumb.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 16, 2004 at 1:37 pm

  #503202

  Who is the owner of the object?

  Check if it is not dbo.