In most of my databases I create, I need to give permissions to do the following:
- SELECT/INSERT/UPDATE/DELETE on all tables in the database
- Execute all (user) stored procedures in the database
Will giving users
datawriter be enough for the sproc's or what other roles/permissions do I need to give?
If I need to do more than just
datawriter, could you point me in the right direction to creating a script to affect all users in the database.
Thanks in advance