Least privilege to execute stored procedures

Hello, in a user created SQL 2000 db where the front end .net app appears to
call on just stored procedures to do all of the data commands (select,
insert, update, delete), it appears that granting table level access won't
be necesarry so what database role should we grant permissions to our valid
windows domain users to have the least amount of privleges?...would it be
the 'db_datawriter' role or something else?

Thanks in advance.


.

Relevant Pages
Loading