3 tables:
security table
--------------
userid vnicholl
email vnicholl@company.com
code1 11111
code2 AAAAA
userid jdoe
email jdoe@company.com
code1 11111
code2 AAAAA
codes 11111AAAAA
base data
---------
code1 11111
code2 AAAAA
total 300.00
codes 11111AAAAA
operating data
--------------
code1 11111
code2 AAAAA
acct 20202
total 100.00
codes 11111AAAAA
relationship
security table has a many to many relationship, both filter for security table filtering base data
security table has a many to many relationship, both filter for security table filtering operating data
When I click the checkbox to apply security filter in both directions, I am not allowed to save it and get a security table is configured for row level security introducing constraints on how security filters are specified. The setting for security filter behavior on this relationship cannot be both.
manage roles
security role is on the security table, with the email id = userprincipalname()
When I look at the report on the desktop, and choose view as, and look as the security role, I see only my data, not jdoe.
When I upload this to my workspace, that doesn't happen. Any idea why not?
