I'm using MS SQL Server 2005. I'm connecting to the server via ADO. I have a question about access rights. Let me explain this with an example.
Let's say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3.
I want to create a SQL Server user that will have all rights on TBL_1 and TBL_2. But I want this user to be able to only read TBL_3 (not delete, update or insert). There is something called schema in SQL Server, but I couldn't understand the use. Would you please tell me step by step how I can set up the access rights.
Step 1: Open SQL manager Logins
Step 2: Do XXXXX
Step 3: Do YYYY
Final step: Connect with the username and password to DB