PostgreSQL query to see users and apps they have access to

mbespartochnyy — Sat, 16 Nov 2024 01:17:08 GMT

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.

Re: PostgreSQL query to see users and apps they have access to

Alan_Slaughter — Fri, 24 Jan 2025 20:22:26 GMT

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:

"Users" table: Contains user information like user IDs and names.
"SystemResources" table: Contains information about apps and other resources.
"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.

topic PostgreSQL query to see users and apps they have access to in Management & Governance

PostgreSQL query to see users and apps they have access to

Re: PostgreSQL query to see users and apps they have access to