Hi!
Is there any way to limit access in SAP for Qlik connector user based on organizational level?
Client has SAP with many companies and we need to limit access only on one plant/sales organization of one company. In help, there is a tutorial for row based access control, where you need to list all tables and restrictions based on fields. But this needs a lot of maintenance and had to change for every additional table. And what happens if table doesn't have appropriate field? Ie. VBRK has VKORG field and VBRP doesn't - how can you solve this? Is this automatically inherited from VBRK?
I know that we can filter out data on Qlik side, but the problem is, that Qlik user must not have access to any other company/plant/sales organization due to security issues (that Qlik developers can't access data from other companies). We are using SAP SQL connector.
Thank you,
BR, Darjan
