Access to execute Store procedures

Hello there

I would like to give my users permission to insert/update/delete data
from/to tables and views

and i also need to give them full access to execute Store Procedures.

In order to do so i gave them on Dababase mode db_datareader and
db_datawriter roles.

This roles are giving them full access to insert/update and delete data, but
it doesn't give them access to execute Store procedures.

Which permission i sould give them wituout give them db_owner?


.

Quantcast