Originally posted by Patrick Chua
I know that you can specify user rights on the particular database. But how about table access.
Can I set rights to a particular user either for read, write for a particular table only?
yes u can...create a new user login for your database which u want to grant restricted access to.Goto your database -> user -> select the new user's properties --> goto permission. From there you can control the access of all tables.