Forum Discussion
userprincipalname() doesn't work plus relationship problems
3 tables:
security table
--------------
userid vnicholl
email [email protected]
code1 11111
code2 AAAAA
userid jdoe
email [email protected]
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?
2 Replies
RLS testing on the desktop differs from RLS testing on the workspace. On the desktop you need to specify BOTH the role and "Other user" with the email address you want to test.
Yes. On the desktop I see it correctly. On the workspace I don't. How do I get it to work at the workspace level?
