MSSQL Login for Stored Procedure

Hello,
I am having a challenge creating a MSSQL Database Login that can ONLY create, delete, execute some few Stored Procedures Only. I dont want that user to be able to view table or perform any other SQL query.
There are 13 stored procedures under the database named "OFFICEDB" and i want the login to be created to only have access to create, delete, execute or alter just 4 selected stored procedures only.
Kindly guide me on this.

How exactly would you enable a login to create procedures that already exist? If that login has permission to delete those procedures then they no longer exist, so anything they create will be different procedures.

I would just grant execute on the procedures to the user you want.

@jmcilhinney and @ GaryMazzone
I just want to create a MSSQL Database Login which will ONLY have access to access stored procedures on the database. It should not be able to view my tables or execute any other thing apart from the Stored Procedure.
I am asked to create the login credentials and send to the guy handling the stored procedure, but i dont want to give him a login where he can use to do anything else or tamper with anything else.

You create the SQL login. You grant connect to the database you want then only grant execute on the stored procedure you want that login to be able to execute..... If it is all SPs in the DB you can grant execute on schema. Or you grant execute on a storeProc itself

You can create the login and add it to the dbExecute role, which should have access to the sprocs... nothing more... That should be sufficient. If you want this user to have access to one and only one sproc, then you'll need to GRANT EXECUTE to that one sproc explicitly.

-tg

Quick question from the sidelines: In which context is a SP executed?
Let's stay with the requirement:
User shall have GRANT's (only those) to execute, create, change and delete a (specific) SP

Let's go with the CREATE-Grant:
That user creates a SP, which contains "DROP TABLE MyTable......."

Is the SP executed within the User-Context?