Blog Post

Azure Data Explorer Blog
2 MIN READ

Row Level Security (RLS) - get more control over your data

slavikn's avatar
slavikn
Icon for Microsoft rankMicrosoft
Mar 01, 2020
We are excited to announce a new Azure Data Explorer (Kusto) feature: Row Level Security (RLS) policy, which gives you fine control over who can access data inside your tables. You can now prevent sp...
Updated Sep 29, 2020
Version 6.0
jamesbdarcy's avatar
jamesbdarcy
Copper Contributor
Oct 01, 2020

One more thing:

 

I did wonder if the kusto function current_principal_details() might hold the key to retrieving the value passed in from EffectiveIdentity. I wondered if one of the following fields returned from current_principal_details() might be updated with the value:

 

{
"UserPrincipalName": "user@fabrikam.com",
"IdentityProvider": "https://sts.windows.net",
"Authority": "72f988bf-86f1-41af-91ab-2d7cd011db47",
"Mfa": "True",
"Type": "AadUser",
"DisplayName": "James Smith (upn: user@fabrikam.com)",
"ObjectId": "346e950e-4a62-42bf-96f5-4cf4eac3f11e",
"FQN": null,
"Notes": null
}

JBD