How to protect particular table from viewing users

Question

Hi friends I want to protect particular table through password or by restrricting user from watching the sensitive data. Is it possible to give password to table or sql database ? We can give pasword to Ms Access file. can we done in sql database? Plz give me solution?....

Zoran Horvat · Answer

You can deny SELECT permission to specific user: CREATE TABLE SomeTable ( SomeTableID INT PRIMARY KEY IDENTITY(1 1) Value INT ) DENY SELECT ON SomeTable TO someuser; Now you let the restricted person to login to database as someuser which has no permission to access the sensitive table. You yourself do not login as someuser but as some other user which has permission to select data from that table. Off course you don't give other persons those credentials. Zoran