Sunday, February 19, 2012

Can I set user rights to table access ?

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?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.

No comments:

Post a Comment