I have created several logins such as ACC, SALES, HR, DIST, ADT and IT. Now I want that the respective login can access (select, insert, update, delete) its corresponding departments' tables. I am using SQL Server 2008 R2 Standard Edition.
But I do not know how to do it.
Please help me to sort out the problem.