Skip to Content
1
Aug 21, 2013 at 06:21 AM

'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

55 Views

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.