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.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Security Access to a table

Author  Topic 

stahorse
Yak Posting Veteran

86 Posts

Posted - 2014-03-10 : 04:12:36
Hi

I 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/role


here we can add the list of users to whom we want to give access at table level.

Regards,
Nagarjuna
Go to Top of Page
   

- Advertisement -