Sharing data to other users?

Authentication & Security
4

I have something somewhat similar.

  1. Table Foo. Define table Foo using Schema. Under Roles/Access, put in the service = Database and the component = Foo and give the role permissions to POST.

  2. Table Bar. Define table Bar using Schema. Under Roles/Access, put service = Database and the component = Bar and give the other role permissions to GET.

  3. In MySQL, create an INSERT trigger on Foo to copy appropriate columns and values of data to the Bar table for its reading.

You might need UPDATE and DELETE triggers too, depending.

I do something similar where the specific transactional info corresponds to Foo and there’s a summarized leaderboard that all can read, Bar.