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 |
|
stahorse
Yak Posting Veteran
86 Posts |
 Posted - 2014-03-10 : 04:12:36
|
| HiI have a database and table dbo.Test_Table, with list of Users under Security -> Users. those users have access to all the tables in my database.I would like to know how do I assign certain users to specific tables (e.g dbo.Test_Table) within the database, that only those Users can view those tables within my database. |
|
|
nagarjuna_a2006
Starting Member
16 Posts |
Posted - 2014-03-11 : 05:45:06
|
| Hi,Expand the object Explorer Select Database --> Select Tables --> Table Name --> Right Click -->Click on Permissions--> Search users --Select user/rolehere we can add the list of users to whom we want to give access at table level.Regards,Nagarjuna |
 |
|
|
|
|
|
Security Access to a table