URGENT& IMPORTANT:Row Level Security with DIrect Query

[rajaniesh]

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