question about SQL server table security

[laugh]

Hello,

How can I manage the security of SQL server?s DB access at table level? Basically, I want to allow the read-only access to a particular table to only several users.

Can someone offer me a walk through on how to set it, probably a step-by-step guide? I have no idea about SQL server admin.

Thanks a lot!

 

[zebano]

press f1. or start playing, it really is trivial.

 

[Goosemaster]

Google it.

Seriously.

 

[MichaelD]

I keep a table cloth over my server table. It hides my table from people that shouldn't be touching it. Works really well, and quite inexpensive; $4.99 on sale at WalMart.

 

[So]

Originally posted by: MichaelD
I keep a table cloth over my server table. It hides my table from people that shouldn't be touching it. Works really well, and quite inexpensive; $4.99 on sale at WalMart.

YAMDTC.

 

[laugh]

well google is no use, but F1 is. 🙂

it's a matter of GRANT syntax anyway.

 

[mugs]

Originally posted by: Goosemaster
Google it.

Seriously.

First link after Googling sql server table permissions:
http://www.databasejournal.com/features/mssql/article.php/2246271

(the answer is yes, and it explains how to do it)