cancel
Showing results for 
Search instead for 
Did you mean: 

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized, when executing CALL _SYS_AFL.PAL_RG

0 Kudos

I am trying to do a linear regression based on this video https://www.youtube.com/watch?v=tpP9Gq6vPAM&t=2s

but when I tried to execute the SQL code, the last statement produces an error.

Last statement: CALL _SYS_AFL.PAL_RG (V_RG_DATA, RG_PARAMS, RG_COEFF, RG_FITTED, RG_SIGNIFICANCE, RG_PMML) WITH OVERVIEW;

Error message: Could not execute 'CALL _SYS_AFL.PAL_RG (V_RG_DATA, RG_PARAMS, RG_COEFF, RG_FITTED, RG_SIGNIFICANCE, RG_PMML) WITH ...' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

I think the reason for this error are missing previliges (SYS_AFL), that I can't grant. When I try to to grant that previlige as SYSTEM user to DEVUSER I get following error:

Could not modify user 'DEVUSER'. Could not grant privilege ALTER on _SYS_AFL You are not authorized to perform the required actions

Accepted Solutions (0)

Answers (1)

Answers (1)

pfefferf
Active Contributor
0 Kudos

Hi Minh,

why and what are you trying to grant manually to your DEVUSER?

You just have to assign the required role AFL__SYS_AFL_AFLPAL_EXECUTE to your DEVUSER as described here. As the SYSTEM user has the system privilege ROLE ADMIN (if not modified) you should be able to assign the role to the user (of course in a real-life scenario you would not use the SYSTEM user for that, but a dedicated user to do such things).

Regards,
Florian

0 Kudos

Hi,

I already granted my User DevUser the role "AFL__SYS_AFL_AFLPAL_EXECUTE", you can see it on the picture.

The System gives me the error for missing authentication starting with this Insert Code:

Could not execute 'CREATE TYPE PAL_T_RG_DATA AS TABLE (ID INTEGER, LIFESPEND DOUBLE, INCOME DOUBLE)' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

pfefferf
Active Contributor
0 Kudos

Ok, that error message is different now to that one in your original message.

Did you set any schema in which you wanna create the type?

You have to check in which schema you wanna create it and if DEVUSER has the privileges for that schema.

Thanks for help Florian. I was able to fix it. I gave the Devuser the right "Data Admin" and now I can Create Tables.