Give permission to user for execute object in SQL server.
grant execute on OBJECT_NAME to USERNAME
Example:-
grant execute on usp_store to user_jasraj
Permission on Table
grant insert on tblName to user_JasRaj
grant execute on OBJECT_NAME to USERNAME
Example:-
grant execute on usp_store to user_jasraj
Permission on Table
grant insert on tblName to user_JasRaj