Post reply

SQL Server Row-Level Security: A Comparison with Gallium Data

  • November 15, 2021 at 12:00 am

    #3948015

    Comments posted to this topic are about the item SQL Server Row-Level Security: A Comparison with Gallium Data

  • November 15, 2021 at 3:17 pm

    #3953195

    Interesting, but what are the advantages of row based security versus simply creating views with filtering and restricting access to these using role based or domain group GRANT SELECT permission?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • November 16, 2021 at 11:03 am

    #3953533

    Hi Eric,

    I think the arguments for SQL Server's row-level security are:

    1. it allows you to control access to your data without changing your schema
    2. it is specifically for access control, and can be managed separately from the schema
    3. it can cover inserts, updates and deletes, which can be difficult or impossible with views

    However, I find SQL Server's approach somewhat inflexible, and I think Gallium Data can add value in some scenarios -- hence this article.

    I think of Gallium Data as a middle ground between databases and applications. If you can solve your problem from either end, then that's probably the best approach, but if you can't, Gallium Data may be a life saver.

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

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