HCP Production - PAL: insufficient privilege when executing SYS.AFLLANG_WRAPPER_PROCEDURE_DROP

[Former Member]

I am using a production environment, and I am trying to run a PAL example.

When executing the call: SYS.AFLLANG_WRAPPER_PROCEDURE_DROP('DM_PAL','PAL_SVM_TRAIN');

I get an error: "insufficient privilege: Not authorized"

When I am trying to assign the roles AFLPM_CREATOR_ERASER_EXECUTE and AFL__SYS_AFL_AFLPAL_EXECUTE to current user, of course I get: "feature not supported: grantor and grantee are identical"

I am using the default user which is associated to the current HCP database, which is supposed to have the required rights.

[Former Member]

I have been able to execute the procedures from the PAL example by creating a new user, assign the rights to it and then login again using the newly created user.

1) CREATE USER DEVUSER PASSWORD Password1

2) GRANT AFLPM_CREATOR_ERASER_EXECUTE TO DEVUSER;

3) GRANT AFL__SYS_AFL_AFLPAL_EXECUTE TO DEVUSER;

4) Eclipse: "Add system with different user.." and login with "DEVUSER"

5) In the schema "DEVUSER" (created automatically) I was able to run the AFL procedures

- call SYS.AFLLANG_WRAPPER_PROCEDURE_DROP('DEVUSER','PAL_SVM_TRAIN');

- call SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','SVMTRAIN','DEVUSER','PAL_SVM_TRAIN',PAL_SVM_PDATA_TBL);

[Former Member]

Hi Marius,

I've played around a little bit with this functionality, have you checked that AFL is installed, it is needed for PAL.

SELECT * FROM SYS.AFL_FUNCTIONS WHERE PACKAGE_NAME='PAL';

Otherwise check out this video from SAP Expert Phil, there is also a modelling role that you might need:

https://www.youtube.com/watch?v=NgpauTjtLV8

[Former Member]

Hi Michael,

The AFL was installed by default on my HCP instance. The link to the video you provided, even if it was related to the Express version, led me to find the correct answer (I will post it).