Row security / hooks

Thread is closed for posting
2 posts, 0 answers
  1. Vincent
    Vincent avatar
    4 posts
    Member since:
    Jan 2011

    Posted 11 Feb 2011 Link to this post

    We are thinking about using the OpenAccess ORM in our product, but we have some advanced scenarios which we are not sure of if they are supported by OpenAccess. We want to enable multi-tenant databases in our product, this means that we need to be able to filter the data that is returned from the database based on the user that is currently performing the requests. Also we want to be able to configure simular scenarios to have row level security to prevent users in a certain role to view parts of the data in the table. Does OpenAccess have hooks or extension points to support the above mentioned scenarios?
  2. Jan Blessenohl
    Jan Blessenohl avatar
    707 posts

    Posted 15 Feb 2011 Link to this post

    Hello Vincent,
    There is not declarative way to specify filters. Nevertheless all queries have an entry point at the generated context. there you can apply the filter to the IQueryable before you give it out. For collection content you can implement the getter related to your needs, just execute the query with the applied filter there.

    Kind regards,
    Jan Blessenohl
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Back to Top