I have a database that is accessed by an application for data updates.
I want to use windows authentication with a domain group
I have created a login with the domain group then created a user in the appropriate database with that login
I have created a database role with select,update,delete,insert rights on the appropriate tables.
The application works fine with a separate user that has a login and user with the required permissions but when a member of the domain group runs the app they can connect to sqlserver but do not have access to the tables.
In Oracle I would create the role, add table permissions to the role and assign the role to the user,
I can't figure out how to accomplish the same thing in sqlserver 2008
View Complete Post