Hi all,
I set up a few table permissions in Portal management. There are a few with child table permissions and I've defined the relationship. I also have 2 webroles, admin with global access to everything and authenticated users with restricted access at contact level.
I then tested the data returned in power pages using standard list/form and they work correctly for both admin and authenticated users.
However, I have CDS issues with a few custom pages where I used fetch xml to return values, and this issue only occurs with authenticated users.
With further digging into the issue, I found out even after having the table permission all set up in Portal managemet (with relationship and all). When I checked the table permission in Power pages design studio, the relationship is missing (which is odd because I thought they are synced). I then selected the relationship directly in Design Studio, this solved the fetch xml CDS issue, but messed up all the other standard form/lists. I went back to Portal Management to check the table permission and the relationship in there is gone.
Not sure if I miss out any set up/configuration to have the table permissions synced. Appreciate if anyone can share their thoughts on this issue.
