February 23, 2006 at 12:07 pm
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
February 23, 2006 at 4:48 pm
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
*****************/
February 24, 2006 at 3:08 am
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