Hi,
In Qlik all manual app reloads and ODAG apps run using the service account on the backend database.
Is it possible that these queries gets submitted/run on the backend database using user specific ID and assigned privileges ,and not the service account.
The problem statement here is as below.
There are different vertical users who can create reports in qlik sense.
On the backend database , users are given access to selective tables pertaining to their vertical .
However since qlik runs with service accounts which has got entire access , the users can explore data corresponding to other verticals as well(via Qlik hub) .
Regards