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. I can't find a way to pull this data. Can someone help me with this?
The Audit tab on the Operator form in the Adobe Campaign Client Console shows all folders that the user has access to and the type of access (R/W/D) to data in the folder. That together with their named rights which control UI elements would be useful. You might want to look at how the client console is retrieving that information.
Thank you for your quick answer! I think I did manage the steps you described, but now I'm struggling to analyse the data / look at the right columns to see the information I need. I'm not sure if you can help me with that. My knowledge about Adobe Campaign is now 8 weeks old so I'm really a beginner and discovering the database structure.