First you will have to create a login and then grant access to DB that the user will connect. It can be a windows user or SQL User depending on your choice of connection.

Once that is done, give access to execute the Stored procs that you have created.

Those are the basic things that we can advice you with the limited info you provided.