Calculation Views and Table Functions fail with error;258 insufficient privilege in HANA 2.0SPS05

[former_member565459]

Hello,

I've a scenario where the queries on Calculation View and Table Functions fail with error General error;258 insufficient privilege.
The same queries run absolutely fine when we re-activate the Table functions and Calculation Views.
This is a repetitive error and requires continuous monitoring.
Is there any permanent fix to the same ?

I checked for the GUID which says USER is missing SELECT privilege.
But, as I said the query runs smoothly when I reactivate the TF or CV.

Result of SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS:

florian.pfeffer , can you help me with this ?

TIA.

Regards,

Prathamesh H.

[manuel_pereztiribelli]

I am facing a similar role. I wonder if you have found a solution.

I think one alternative is to use wildcards in the role (I have not tested it)

[former_member565459]

Change the table function from INVOKER to DEFINER security mode so that SELECT privilege on the object that was permanently dropped/recreated was not required anymore.