add the user to the database role "db_datareader" and "db_datawriter. Then grant execute all or grant execute on specific stored procedures if they use them. Or grant db_owner role on that database.
If you want the user to be able to add others to these roles, then make them db_owner or db_securityadmin