MS SQL server database permissions and users
So, I have a database, lets call it 'till' and a piece of software to administer the data in that db. The application uses the logged in users details to connect to the db, and the users with permissions are a member of an active directory group 'till-managers'.
Can someone describe the process to me of adding permissions on the DB server to allow everyone in that group read and write access to the database I want.
As it stands, I've added DOMAIN\till-managers as a login, set the default db as till and set user mappings for that database with the roles 'db_datareader' and 'db_datawriter'.
I should also mention that the app makes use of stored procedures, views and normal tables.
What am I missing?