I would like to know exactly what rights are needed to retrieve data from a database via endpoints?
Do we agree that on my database side I could technically create a user with only read rights on the table I am interested in? I don't need my user to be an admin of my database?
I take the opportunity to ask another question, would there be a way (call API or other) to retrieve exactly the list of users who can see, write or administer an instance? This way, a person seeing only his QLIK Replicate instance dedicated to his service, could make sure that other unwanted person could see the list of his tasks or endpoints.
Please change the filter on the top left for the version of Replicate you are running, then check the source database types you are using.
For your second question, you can view the permissions granted in Replicate on the Server page, User Permissions tab. You may need to compare this with the list of members in the domain groups you have defined.
You can set more granular security if you use Enterprise Manager, which you can learn more about here:
