Cannot grant execute to stored procedure [closed]

Question

When I try to GRANT EXECUTE ON SP_NAME TO [DOMAIN\USER_NAME] on my database, I'm getting the error message below:

Msg 8115, Level 16, State 1, Procedure grant_safety, Line 5
Arithmetic overflow error converting IDENTITY to data type smallint.
Arithmetic overflow occurred.

This is happening in any procedure where I try to GRANT EXECUTE permissions; I have tried to grant to other users as well, but same error.

ALTER PROCEDURE TEST  
AS  
BEGIN  
   SELECT 1  
END

Answer 1

Try putting a GO on a newline between your procedure DDL and your grant statement and after the grant.