Tabular - Dynamic Row level security - does not work RRS feed

All replies

  • How are you testing this? Row Level Security is not applied to server admins, so if you tested by putting yourself in a role it will not work. If you have been testing putting other users into roles it's worth checking that they are not server admins.

    If you run SQL Profiler listening for the Existing Session and Session Initialize events while you test these roles you will see the list of roles for a user in these events. If you see a * the user is in the server admin group. If you see multiple roles listed this can also cause issues depending on how you configured your roles - please mark correct answers

    Monday, July 22, 2019 11:10 PM