Kerry,

Are you going to use only Stored Procs from your App? If so then you can give permission to execute to each seperate sp.

Grant execute on STOREDPROCNAME to USERYOUCREATED