User rights for endpoint connection to DB

ablanc — Thu, 15 Dec 2022 16:44:32 GMT

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.

Re: User rights for endpoint connection to DB

Dana_Baldwin — Thu, 15 Dec 2022 18:00:43 GMT

Hi @ablanc

The security rights required vary depending upon the source database type you are working with, please refer to our documentation here:

Adding and managing source endpoints ‒ Qlik Replicate

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:

Qlik Enterprise Manager – Data Ingestion Management | Qlik

and here:

Welcome to the Qlik Enterprise Manager online help and API guide ‒ Qlik Enterprise Manager

User permissions ‒ Qlik Enterprise Manager

There is also an API available for listing users in Enterprise Manager:

GetServerAcl ‒ Qlik Enterprise Manager

I hope this helps!

Dana

topic Re: User rights for endpoint connection to DB in Qlik Replicate

User rights for endpoint connection to DB

Re: User rights for endpoint connection to DB