Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Row-level security for users belonging to multiple AD groups? RE: Row-level security for users belonging to multiple AD groups?

  • February 9, 2018 at 3:53 pm

    #1979325

    I believe your performance issue is related to the following OR statement:
    OR IS_MEMBER('domain\DEV_ADMIN') = 1;

    An option is the use disjunction in the predicate. Please look at that: