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