Record-level access control without redundant reference

Authentication & Security
1

Hi DF team,

I followed this documentation to control access at record level. However, to achieve the result I need to add the reference field to every tables that I need to gain access control. For example, let consider this use case:

  • I have 2 tables: orders and order_items link to each other via a foreign key (let say an order_id).
  • In order to gain access control at orders table, I added a field owner_id to the table and use that field to filter access control.
  • In order to gain access control at order_items table, I also need to add owner_id field.
    ==> But does DF support other way to achieve this goal (for example: linking the filter via foreign key) without adding redundant data to all tables?

Thanks in advance for your time and support.