question about SQL server table security

laugh

Golden Member
Dec 21, 1999
1,239
0
0
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!

 

MichaelD

Lifer
Jan 16, 2001
31,529
3
76
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

Lifer
Jul 2, 2001
25,921
14
81
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

Golden Member
Dec 21, 1999
1,239
0
0
well google is no use, but F1 is. :)

it's a matter of GRANT syntax anyway.