Section access

[youss123]

Hello everyone,

I want to set up the security of my application:

Indeed, I have 3 types of profiles:

• profile 1: a doctor who must access the stays of his own patients,
• profile 2: a coordinator who must access the stays of the patients of the entire clinic to which he belongs
• profile 3: administrator who must access the stays of the patient stays of several clinics to which he belongs

My need is to know how to choose the right keys to have this result and how the shape of the Access table will be

Let me know if you need more informations.

I have attached the columns of Table stays.

Thank you for your help 

Youssef

[youss123]

Hello everyone,

I want to set up the security of my application:

Indeed, I have 3 types of profiles:

• profile 1: a doctor who must access the stays of his own patients,
• profile 2: a coordinator who must access the stays of the patients of the entire clinic to which he belongs
• profile 3: administrator who must access the stays of the patient stays of several clinics to which he belongs

My need is to know how to choose the right keys to have this result and how the shape of the Access table will be

Let me know if you need more informations.

I have attached the columns of Table stays.

Thank you for your help 

Youssef

[rubenmarin]

Hi, at the end you can use stays to limit the information to all kind of users.

1.- Load doctors users and their stays

2.- Load coordinators users with their clinics, and do a join to bring all the stays of that clinic

3.- Load administradors users and do a join to bring all stays of the clinics they belong

4.- Concatenate all tables.

5.- Do the section access table using USER, and STAY as the reduction field.