I'm having trouble setting up privacy rules for my data

Need help Database
1

Hi all, I have two tables:

  • Businesses– stores all the businesses.
  • Admin Profiles – contains a reference to both a User and a Business.

What I want is for users to be able to manage multiple businesses (sub-businesses). So when a user logs into the portal, they should only see and manage the businesses they are linked to.

The issue is, I’m not sure how to set up the privacy rules so that users can only access data for the businesses they have permission to manage, and not see data from unrelated businesses.

2

Add a list field of type ‘Business’ to the User datatype, and add a privacy rule to grant access to the Business Datatype only when the Current User’s Businesses contains This Business.

Use the same rule for any other data associated with a Business.

1 Like