Calculation View Security
How can I configure Calculation View security such that the modeled views it consumes are private to the end users.
For example if I have a Analytic View that is consumed in a Calculation view I want to prevent the end user from being able to run the Analytic View Directly but still be able to consume the Calculation View.
Tags:
Vivek Singh Bhoj replied
Hi Michael,
When you assign privileges to end user don't grant him MODEING role and access to _SYS_BIC schema.
But only grant access to the particular view in _SYS_BIC schema.
Don't grant _SYS_BI_CP_ALL analytic privilege but create an analytic privilege for your Calculation View.
Then grant select access to _SYS_BI schema, analytic privilege that you created and select privilege on Calculation View that you just created.
Additionally, you can check my blog:
HANA Security: Creating End Users with minimal rights
Regards,
Vivek