Hi,
We want to apply row level security for our BTP CAP JAVA application based on the user. The same row level security is also required for our SAC reports. We are aware of two separate approaches - role collections for BTP, and analytic privileges for SAC - to do this. In order to use a single approach, we have been trying to follow this blog to use analytic privileges to apply row level security for the BTP users by mapping them to SAP HANA Cloud database users based on the JWT token created during authentication. However, the application is always connecting to the HDI container using the same technical user which is generated during deployment, irrespective of the BTP application user. Does anyone know of any approach which can help us do this?
Thanks,
Ananya