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