• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic RLS Issue

C

cpadilla0024

Member
Cannot get past this issue. I have a couple relationships built in order to get to my table (pictured). Users is a feed from our directory. Cost Center Lookup is a unique list of our cost centers. And Data is the data from our ledger that measures are being ran on. Relationship is CostCenter->Cost Center->Cost Center (left to right). The other picture is how my Users table looks for one user (as a sample). The user list is about 1m rows long and can contain duplicate Cost Centers because it is by user (both in columns). I think that may be why it is giving me an issue but I am not 100 on that. I am using USERPRINCIPALNAME() and referencing the EmailAddress field.






1779230599691.png1779231044880.png
1779231055505.png
 
UPDATE: I am trying to do this same sort of thing but I need the RLS to apply to 2 different tables. I got it to work correct for my Data table but I am having issues with making it also apply to Transactions. I am getting ambiguous paths. Cost Center Lookup is also used for RLS for people that have a division scope. Users is for cost center level (granular and would not make sense to create a role for the hundred of cost centers). Please help!

1779297604010.png
 
You must log in or register to reply here.
Back
Top