PostgreSQL query to see users and apps they have access to

[mbespartochnyy]

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.

[Alan_Slaughter]

Hi maybe this might be helpful:

To view the users and the apps they have access to in Qlik Sense, you can query the PostgreSQL database that stores the repository data. The relevant tables are:

1. "Users" table: Contains user information like user IDs and names.
2. "SystemResources" table: Contains information about apps and other resources.
3. "SystemResourcesAudit" table: Stores access rights for users on different resources.

You can join these tables to retrieve the desired information. For example:

SELECT u.Name AS UserName, sr.Name AS AppName FROM Users u JOIN SystemResourcesAudit sra ON u.Id = sra.ModifiedByUserId JOIN SystemResources sr ON sra.ResourceId = sr.Id WHERE sr.ResourceType = 'App';

This query may return the username and the app name for each user that has access to apps in the Qlik Sense environment.