Post reply

Table permissions for a user

  • March 29, 2006 at 9:26 am

    #189931

    Hi there,

    Can anyone tell me how (in sql server 2005)to give a certain user permissions to some tables in a database but not to others?

    Thanks

  • March 30, 2006 at 3:11 am

    #629761

    OK, I solved this problem. One has to click the user, navigate to security elements and select tables as an an object type. Then choose the table followed by the permissions for this table.

  • March 30, 2006 at 7:19 am

    #629830

    Strictly speaking you should create a schema to group the objects, and a role to group the users.

    GRANT SELECT ON SCHEMA :: schemaname TO rolename

    Any users you don't want to have the access, don't add them to the role.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply