Unanswered

Power Pages Account records create,read,and edit others read only to records

(0) Share

Report

Posted on by mjackson122

Currently I have the account functionality working correctly using the default web role authenticated users. When a user signs-in they only see cases that belong to their account via the account table. However, when I create new table permission on the same case table with the global permission and read-only. The users still only see their account records in the list.

Desired outcome is to show all records on the list, however if you open a record that matches your account you can perform CRUD. If you open a record that does not belong to your account read-only access.

I have one web role so far the default authenticated.

Categories:

Security

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Fubar 8,493 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Did you add the new Table permission to the Authenticated Users web role (or another web role that is directly assigned to the contact)?

After creating the Table permission did you clear the portal cache (re-preview from in the Site Designer or manually from the portal <siteurl>/_services/about when logged in to the portal as a user with the Administrators web role assigned)

Was this reply helpful? Yes No
mjackson122 on at

Like (0)

Report
Copy link

Link copied!

Originally I did create a new table permission with the authenticate web role assigned. Then I had two table permissions:
1) Account only CRUD Authenticated role case table
2) ReadOnlyNonAcount Read Authenticated role case table
HOwever, the above configuration did not work, it still just displayed all of the account cases for the user signed in they did not see the whole list of cases.
I am trying to determine what permission I need so the signed in user can see all the cases but can perform CRUD only on cases associated with their account and read-only for cases that are NOT associated with their account.

So now I just have the one table permission Account assigned to the authenticated role with the CRUD functions.

Was this reply helpful? Yes No
Fubar 8,493 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

1 Table permission on Case scope = Global with Read

1 Table permission on Case scope = Account with CRUDAA (on the customer account relationship)

Both assigned to the same Web Role.

Was this reply helpful? Yes No
mjackson122 on at

Like (0)

Report
Copy link

Link copied!

That's what I originally tried and it did not work. The list just shows cases associated with users account where they can perform CRUD actions. The list does not reflect other cases that are not their account for read only.

Was this reply helpful? Yes No