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 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

Data Modeling

3 Replies

  • 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

       

    • msudulag's avatar
      msudulag
      Helper II
      8 years ago

      Hi v-haibl-msft,

       

      Can you please suggest how can i achieve this requirement.

      can you give any examples.

       

      Regards

      Msudulag