Restricting user(s) in SQL access to TABLES vis SQL Management Studio
-
Hi,
Can anyone please help me with the sql permission issue.
I have a database on sql server 2008 and I want to restrict a user(s) to access some tables in the database.
Can anyone please advise some help.
Regards,
-
If you want to restrict a set of users, first create a ROLE, assign those users to this ROLE and REVOKE all the permissions for this ROLE on a speicfic object (a table in your case)
http://msdn.microsoft.com/en-us/library/ms187719.aspx
- Lokesh
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
See Topics on Grant,Deny,Revoke you will get better understanding.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply