cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

URGENT& IMPORTANT:Row Level Security with DIrect Query

Hi,

I am using DB2 database as a Datasource with Live connectivity and want to create a Row level security by mapping customer ID with Users roles for 14000 users(i.e. Customer ID BAC123 belongs to customer 1). We want to give Read and Edit permissions to these users. Edit permission is given to develop the report with composite model wherein users can bring their own data and join it with the exisitng data in DB2.

 

Now if user who have the edit permission to the report he/she can edit the role and mapping and view the data from other customers. How do we avoid it. is there any permission to restrict the access to change the roles and permissions but still use composite model and edit the report.?

Regards

Rajaniesh

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.