Post reply

View\User based Horizontal Partitioning

  • August 23, 2012 at 9:09 am

    #280146

    Hey all,

    If i have a table. This table has data for 100 clients.

    Each client needs secure access to see there own data. Whats the best way of doing it?

    I am thinking of having a view that uses systemuser to detirming what rows from the underlying data and only display the required rows? Would this be secure? Or would this expose the entire underlying table to a select statement?

    Whats the best way of doing this?

    Thanks In Advance.

    Dan

  • August 23, 2012 at 1:05 pm

    #1529429

    Your comment about filtering using the security metadata available for the logged in user (e.g. by using ORIGINAL_LOGIN() or SUSER_SID()) is where I would go with it.

    See the section titled Tenant View Filter:

    Multi-Tenant Data Architecture

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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