I'm using Ms SQL Server 2005. I'm connecting server via ADO.
I have a question about access rights. Let me tell this with an example.
Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3.
I want to create a SQL user which will have all righst on TBL_1 and TBL_2. But I want this user to be able only reading TBL_3 (ne delete, update or insert). There is something called shemma in SQL server, bu I couldn't under stand the usage. Would you please tell me step by step how I can to things above.
Step 1: Open SQL manager Logins
Step 2: Do XXXXX
Step 3: Do YYYY
Final step: Ceonnect with the username and password to DB
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!