Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmjy001
Starting Member
1 Post |
 Posted - 2012-07-22 : 23:06:31
|
| 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.Regards, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-23 : 00:42:23
|
| create a role that has access only to required tables in database and assign required users to itFor creating role use CREATE ROLE http://msdn.microsoft.com/en-us/library/ms187936.aspxfor giving access to table use GRANT..and for adding uses use sp_addrolemember------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Restrict user to access certain tables in the data