✏️ Explanatory Question

What is Dynamic Row-Level Security?

👁 4 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Dynamic RLS automatically filters data based on the logged-in user's identity.

Example DAX:

[Email] = USERPRINCIPALNAME()

Instead of creating multiple roles, a single role dynamically applies security filters.

Benefits:

  • Easier maintenance.
  • Scalable security model.
  • Ideal for large organizations.