Hi everyone,

I'm working on developing a new security rules set for my Qlik Sense environment and wanted to get a list of users and apps they currently have access to. I tried using Audit section of QMC, but it doesn't give me exactly what I need. I would like to get a table with the following columns:

• User ID
• Stream Name
• App Name
• Sheet Name
• User Access Privilege

I have access to PostgreSQL and I dug through tables of public schema that's in QSR database and found Users, Streams, Apps and AppObjects tables so I can get Stream Name, App Name, Sheet Name and a list of users, but I'm struggling to find a way to connect users to apps they have visibility into as well types of privileges they have for each app.

Does anyone have a query handy that I can use for that? Or maybe not the query, but if you can point me to at least the right database and table(s) that I can read from to get list of users and apps they have access to, that'll be helpful as well.

Thanks in advance!

Mikhail B.