thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Dynamic Row-Level Security

RLS that filters data using the signed-in user's identity, typically through USERPRINCIPALNAME() and a user-to-entitlement mapping table.

Definition

One dynamic role scales to many users, whereas static roles need one role per value. The mapping table filters the dimension, which then filters the facts.

Exam tip

Many users each seeing their own region with one role = dynamic RLS with USERPRINCIPALNAME().

Related terms