HANA calculation view ( table restriction)

[former_member195748]

Hello SAP experts,

I have a simple scenario. I have created a Calculation view on 2 tables, Table - X and Y.

There are 2 users- "Thor" and "Hulk". THor has full access, but I want to restrict "Hulk" .

How do i restrict "Hulk" to only see data from Table X. as soon as i give both users "_sys_bic.CV" access both users
can see all the data , unless i create Analytical Privilge and restrict them the row. But my scenario is to restrict/not authorize HULK unless he gets TABLE access.

In short, is there any way data access on TABLES can be restricted in calulation view ( not just the rows).

Regards,

Vivek

[pfefferf]

There is no standard way to do that what you require, not in the XS Classic world and not in the XS Advanced world (with HDI).

Normally it is determined based on attributes of the table if a user is authorized for the data or not via an analytic privilege. If no such attribute is available probably it makes sense to add such an attribute if you have the requirement to apply restrictions on them.

In case you do not wanna do that a (creepy) creepy way would be to extract the data determination for the tables in separate table functions which then needs to be used in projection nodes of your calc. views. In the table functions you can determine the user via the session context, check if he has the select privilege for the table (e.g. via the effective priviliges table) and return the data from the table (if privilege is assigned) or an empty result set (if privilege is not assigned). This is not a recommend approach, because of different reasons (... no standard way, performance ...).