Filtering Using Manage Roles

[Anonymous]

Hi,

I have the Below Tables, and they are related by EmployeeName. I am trying to create a security for Row Level .

I using [lnemployee] as a filter in LoanDetails , but is it possible to use [MgrEmailAddress] as well  from the EmployeeHierarchy table into the LoanDetails Filter.

Regards,

[v-yuezhe-msft · Accepted solution]

@Anonymous,

No, it is not possible to use  [MgrEmailAddress] from the EmployeeHierarchy table into the LoanDetails Filter.

You don’t need to add any expression in LoanDetails table, just add “[MgrEmailAddress]= usename()” expression in EmployeeHierarchy table. As you have created the relationship between the two tables, the LoanDetails table will be filtered to return correct rows with the “[MgrEmailAddress]= usename()” expression.

Regards,
Lydia

[Salvador]

Hi,

I use the email too, but since we have a "complex" employee hierarchy, I use different rls for each hierarchy, and to check the email with the user, i use this: