Predictive Analytics Authorizations
Hello, We are trying to use predictive Analytics for the first time.
We granted the following authorizations:
Now when we try to run a simple predictive we can see that HANA tryies to run the following statement:
CREATE PROCEDURE "TEST_PREDICT_MODEL_PAS2_3" (IN input1 "APR_MODEL_PAS2_3",IN input2 "APR_TYPE_PAS2_3", OUT result "COMP_APRMODEL_STORE_TYPE_PAS2_3") LANGUAGE RLANG READS SQL DATA AS BEGIN attach(input1);attach(input2);library(arules);model_char1
Could not execute 'CREATE PROCEDURE "TEST_PREDICT_MODEL_PAS2_3"(IN input1 "APR_MODEL_PAS2_3",IN input2 ...'
SAP DBTech JDBC: : insufficient privilege: Not authorized
Which authorizations are missing? What did we miss?
Kurt Holst replied
Thanks for the quick feedback.
Well the missing results on the APL functions is not the problem as this is unrelated to the HANA ABC Analytics (PAL).
I see that you have a RLANG call in your scripts. If you want to use the R language then you also need to provide that priviliges to your user. "Create R Script" as shown below:
May I suggest that you take a look at this article - in the appendix you find an end-to-end scenarios where HANA Script is used with the PAL:
Best regards, Kurt