Forum Discussion

msudulag's avatar
msudulag
Helper II
8 years ago

each user having different role and application wise data display

  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...
Data Modeling
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
8 years ago

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's avatar
msudulag
Helper II
8 years ago

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