Hi I'm working on a segregation of duties matrix, in the attached table are permission descriptions for an ERP system. I want to build some rules that identify permissions that are not compatible.
For example, based on the attached qvw I would like to highlight instances where the same user has acess to F_CO_V and F_CO_SHIP_F.
Any ideas on how this can be acheived? in the real data set there will be several users.
I'd go for a table where I can configure the different possible security 'exceptions' per user, because I'm assuming there can be different kinds and not just where users have access to 2 different tables; I'm guessing it could happen in any amount, and that can make an if() very complex.
