Issue: While activating the Analytic Privilege, you might experience the below error in SAP HANA:
Cannot use structured privilege for view not registered for STRUCTURED PRIVILEGE CHECK
Solution: The detailed solution is outlined in the below SAP note:
2439931 – Cannot use structured privilege for view not registered for STRUCTURED PRIVILEGE CHECK
However, this error occurs, if the Analytic Privilege check for Calculation View has not been set.
To resolve this error, ensure that the Apply Privileges drop down for the Calculation View, (View from the Properties tab) has Classical or SQL Analytic Privileges selected.
You might experience the same error if the setting is set to one type and your Analytic Privilege is of the other type. Ensure that both are the same.
- 6 Tips to secure HANA DB - January 24, 2022
- Best Approach for building SAP HANA Privileged based roles - July 27, 2018