Error Message:

Msg 229, Level 14, State 5, Procedure test, Line 1
The EXECUTE permission was denied on the object ‘test’, database ‘AdventureWorksDW2008R2’, schema ‘dbo’.

This error occurs when the user does not have execute permissions for the procedure on the database.

– Ask your DBA To grant you execute permissions on the procedure.

GRANT EXECUTE ON OBJECT::dbo.test TO username
dbo.test – is the procedure name
username – is the name of the user

Leave a Reply

Your email address will not be published. Required fields are marked *