Previous Page | Next Page

BI Row-Level Permissions

BI Row-Level Permissions, Identity-Driven Properties, and Missing Values

If a connecting user doesn't have a value for the identity-driven property that a query uses, the generated query uses an empty string as the substituted value for that identity. If the table against which the query filtering is performed includes empty string values in any rows, those rows are returned to the connecting identity.

Returning data in a missing value situation is a new behavior in this release. In previous releases, a missing value generated an error and prevented any rows from being returned.   [cautionend]

Here are some alternatives for addressing missing values:

Previous Page | Next Page | Top of Page