Setting up access rights in a SQL Server 2005 database

Tags:
Access Rights
ADO
Permissions and settings
SQL Server 2005
SQL Server security
Hello, 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. Like; Step 1: Open SQL manager Logins Step 2: Do XXXXX Step 3: Do YYYY Final step: Connect with the username and password to DB Thank you!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello,

Here you can find a good reading for this: Granting permissions in SQL Server 2005.

In addition this question was answered here: Access rights in SQL Server 2005 users.

Bye

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following