Row level security for logins RRS feed

  • Question

  • I m using MS Access as a front end and i would like to achive row level security for rows in table.
    What i would like to do is f.e. if a specific user sign in to SQL Server through MS Access I would like the sales table for him to filtered for sales that he only did. He can still select, update insert rows to that table but he cant see a ceratin content. I was trying to achive it through table function - i gave a user permission to select update and insert to table function which is nothing else then filtered sales table, but in order for him to update and delete a row it tells me he need select permission on the sales table. if i give him select permission he will see all the content.
    How to achive it.

    Thank u

    Thursday, March 12, 2009 1:47 AM


All replies