each user having different role and application wise data display

[msudulag]

Hi All,

I have user,application,role information my table,

while user seeing a report there is a validation need to be implemneted like

if the user is Admin for particular application he can see alll data related to that application and he is other then Admin he needs to see only his related data.

for data reference i am attaching screen print.

how can i achieve this scanario,please help me on this case.

Regards

Username,Application and role nameMsudulag

[v-haibl-msft]

@msudulag

So there is another table which includes the user emails, which has relationship with this table?

Maybe we need to create a crossjoin table using the USER_NAME and APPLICATION_NAME columns, then create another column to identify if this row is visible to current user.

Best Regards,
Herbert

[msudulag]

Hi @v-haibl-msft,

Can you please suggest how can i achieve this requirement.

can you give any examples.

Regards

Msudulag

[msudulag]

Hi @v-haibl-msft,

Thanks for your reply,

Actuyally these are three tables(Users,Applications and Role),i have combined and made it one,now i need to check the conditiondtion from here only.

I am attaching screen print of my model,Please verify once ,

let me know if you need any information.

Regards

Msudulag