How do we Control Odata Read Requests ?

[former_member322469]

Let us assume that we have a Table with Crucial Data . Once we have created a odata service and exposed the Data , The Hana Authorization lets us control if the USER has access to the service or Not . What if we have to selectively filter the Data  ?

I understand that during a create/update/post there is a modification exit. But do we have a way to check against a row data during read/Select/GET?

Thanks.

[Former Member · Accepted solution]

Hi Ashwin,

One way to tackle this situation is to create an attribute view on top of this table and use this attribute view in your Odata model.

You can create an analytical privilege to control the attribute level filter for the user and assign it to the user. A dynamic analytical privilege can also be created if you want different users to view different data from this information model.

Regards,

Anil