I have a stored procedure (below) that definitely exists and I am trying to execute it as a user which definitely has permissions. I checked this more times than was necessary. But I still get the following error
Cannot find the object [stored proc] because it does not exist or you do not have permissions
I found that if I removed permissions, than I got a more accurate message stating that I did not have execute permissions.
I tried scripting the stored procedure and giving it a different name, but this didn't help either.
CREATE PROCEDURE [dbo].[Child_Get]
@ID int
AS
BEGIN
SELECT * FROM [tblChilds] WHERE [ID] = @ID
END
GO
GRANT EXECUTE ON [dbo].[Child_Get] to 'BLAH\NT4Name'
GO