'CALL _SYS_AFL.PAL_ANOMALY_DETECTION(PAL_AD_DATA_TBL, "#PAL_CONTROL_TBL", PAL_AD_RESULT_TBL) with ...' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

[venkataramana_paidi]

Hi ,

I am practicing the PAL in SAP HANA cloud system . I am running the below statement  but it is throwing error.

CALL _SYS_AFL.PAL_ANOMALY_DETECTION(PAL_AD_DATA_TBL, "#PAL_CONTROL_TBL", PAL_AD_RESULT_TBL) with overview;

It is giving the below error.

Could not execute 'CALL _SYS_AFL.PAL_ANOMALY_DETECTION(PAL_AD_DATA_TBL, "#PAL_CONTROL_TBL", PAL_AD_RESULT_TBL) with ...'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.

PAL_ANOMALY_DETECTION  procedure is exists in the _SYS_AFL schema.

I created the user USER1 and created the schema DM_PAL. I am trying to  give below authorization  under DM_PAL schema  like

GRANT SELECT ON  DM_PAL.PAL_AD_RESULT_TBL TO SYSTEM;

Please help me what are the authorizations I have to give to execute the above procedure.

If any authorization I have to give  can I give under DM_PAL sql query?

Thanks & Regards,

Ramana.

[former_member212487]

Running PAL 10 clustering on SPS10

Same issue

Adding grants to the DEVUSER (in fact I added all the AFL__ grants roles) doesnt help

Could not execute 'CALL _SYS_AFL.PAL_AD (V_AD_DATA, AD_PARAMS, AD_RESULTS) WITH OVERVIEW'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized