• Guest, The rules for the P & N subforum have been updated to prohibit "ad hominem" or personal attacks against other posters. See the full details in the post "Politics and News Rules & Guidelines."

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,914
3
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.
 

ASK THE COMMUNITY