Hello,
I am trying to select (select * from "_SYS_BIC"."sac.calculation_views/cv_provision_transaction_2") a calculation view created in the SAP HANA web-based development workbench but the below error message appears :
PM (SQL Editor) Could not execute 'select * from "_SYS_BIC"."sac.calculation_views/cv_provision_transaction_2" '
Error: (dberror) 258 - SQL error, server error code: 258. insufficient privilege: search table error: insufficient privilege: Not authorized: line 1 col 60 (at pos 60)
The calculation view is created from a view from this view :
CREATE VIEW THEMIS.sac_provision_transaction
AS
SELECT "ID",
"SiteID" AS "Site",
"Quantity",
"ProductID"
FROM themis."ProvisionTransaction";
The user used has the below roles and priviledges
I executed this :
GRANT SELECT ON SCHEMA "THEMIS" TO _SYS_REPO WITH GRANT OPTION
Thank you for your help.
Sincerely,
Axel