If you right-click a database in Management Studio and go to the Properties of the database, there is a Permissions menu choice.
You can Grant Permissions for a login to Delete or Insert or Reference or Select or Update or Execute for the whole database.
The Execute will be good for executing SPs and SELECT for readonly access to tables.
Thomas
Thomas LeBlanc, MVP Data Platform Consultant