• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

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!
0
Chris
Asked:
Chris
1 Solution
 
jmoss111Commented:
Hello Orcadian,

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


Regards,

Jim
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now