Generally, SPs need to be given EXEC permission for those who need to run the SPs.

For this, permission will be provided after creating / altering the SPs like

GRANT EXEC on

- Here PUBLIC can be used to provide EXEC permission to ALL who have access permission to the DB / Server.

You can give the specific permission for the User using:

GRANT