topic Data Connector with different role/permissions for users in Management & Governance

Data Connector with different role/permissions for users

ambasadorknz — Sat, 16 Nov 2024 04:55:46 GMT

Hi,

I have a problem with sharing data connector for many users with different permissions.

I create a data connector "XXX" to schema on database "Alfa".

What I need to do is share connector for 2 users (I have build a role to share the connector, and i gave access to connector "XXX" for users A and B - it works:) ), but user A should see/use only table: A,B and user B only C and D.

Is it possible??

Does anyone have a solution to the problem??

Please help:)

Re: Data Connector with different role/permissions for users

shaun_lombard — Tue, 20 Aug 2019 04:58:52 GMT

What is your target database environment?

If SQL Server you could implement two data connections using 2 separate SQL Logins, or if you are worried about using SQL Logins (like we are) then you need to look at implementing SSO (single sign-on) using kerberos.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/SQLServer/Setting-up-SSO-for-MSSQL.htm

Re: Data Connector with different role/permissions for users

ambasadorknz — Tue, 20 Aug 2019 07:21:51 GMT

My database is Oracle.

Database has ACL with domain/user authorization, so I need create "technical" account for QS user.

DB architecture has some restriction and I cant create more than one account per user, thats why i need to do everything using one QS account on DB.

Do you/anyone have any other ideas??