Password Protect Table in SQL Server 2005 Express (Linked to Access)

I have a database with multiple tables.  One table contains sensitive information.  I would like to give only certain users access to that table, while denying other users access to that table.

I am using SQL Server Management Studio Express to manage the database.  I am connecting to the SQL Server back end via an MS Access front end.

Thank you for your help!
ChrisIT ManagerAsked:
Who is Participating?
 
jmoss111Connect With a Mentor Commented:
Hello Orcadian,

USE MyDatabase;
DENY SELECT ON OBJECT::MyTable TO jmoss111;
GO


Regards,

Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.