Skip to Content
0
Jun 09, 2020 at 11:10 AM

Structured Analytical Privilege - Insufficient Privilege - SQL Exception

99 Views

I have create a calculation view and attached a analytical privilege to which has a Procedure attached to it as condition provider . I am executing the secnario in HANA 2.0 SPS4 XSA environment . Have followed all the steps as documented in the help page in example 3 (Examples: Securing Views Using SQL-Based Analytic Privileges - SAP Help Portal)

The Procedure produces a simple out filter

Have tried multiple output formats like ( RBUKRS in ('1010') ;

I always get the error

The Analytical privileges are assigned to the executing User . I can independently execute the procedure and the View (without AP) . Only when we attach an AP i have an issue .

Any pointers would help.

Thanks

Attachments

procedure-out.png (10.3 kB)
error.png (120.5 kB)