Rights in Sql Server 2005

  • Hi,

    I understood that SQL Server 2005 allow row-level rights.

    Can anyone tell me how to do it? Some examples, maybe, it would be very usefull to me.

     


    Daniela

  • About the only way to control row level rights is through views.  If you create a view that returns only rows that meet certain criteria, then grant a user permission to access that view, at the same time denying the user direct access to the table, you will have effectively granted row level rights to the user.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • Hi,

    I can't believe I didn't think about it : easy and efficient.

    Thank you


    Daniela

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

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