-2

Table1: User UserId, UserName Sample: U001,Mallik

Table2 Role: RoleId, RoleAction Sample: R01, account/delete R02, account/create R03, account/Read

Table3: Eligibility UserId, RoleId Sample: U001, R003 U001, R008 U002, R001

Table4: Activity UserId, Action, Time Sample: U001, account/create, 7-08-2023

I am able to list down the User utilized actions & roles.

Now I want to list down unused roleactions to which user has access to.

UserId - Role Id - RoleActions (which are not in Activity Action table)

PLease help.

Mallikarjuna Reddy
  • 1
  • 2

0 Answers0