I would like to create a workflow with a query that will give me an overview of the actual user rights per user including exceptions (of 170 users). I can't find a way to pull this data. Can someone help me with this?
In another forum I already received this answer but unfortunately I do not think this gives me the right information:
An operator can be directly connected to names rights or it will be part of an operator group which is then linked to a named right.
1.Use a query activity to get all named rights.
2.Perform a change dimension to obtain Operator Groups. In the change dimension activity select (All records).
3.Then again perform a change dimension to get operators from xtk:operator schema. Again select all records.
4.Repeat the above methodology to start from named rights and a direct change dimension to operator (all records).
5.Perform a Union on output from Step 3 and Step 4.