How to assign multiple values in Data Access Controls in DWC?

[julienleloup]

Hey experts,

I'm working on a DWC project that includes setting up row level security via Data Access Controls. However, in most cases the users need access to multiple plants. For now it seems that I need to create a record in my table for each user/plant combination, meaning there might be multiple records for the same e-mailadress.

This becomes very confusing, as I have 400 users to set up and my table becomes 1500+ records long.

Is there a way to add multiple values at once, so we keep one record per user?

Thanks,

Julien

[s_schneemann1]

We are currently in a similar situation. What we have done: we have created a local table in which each user has a single row for authorizations. This table is transformed via SQL View so that it fits DAC format.

[XaviPolo]

No. At this time a row for each user/element is needed.

check out the comments on this blog

https://blogs.sap.com/2020/09/22/data-access-control-in-sap-data-warehouse-cloud-beta/comment-page-1...