Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 29, 2017 at 06:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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).

  • avatar image
    Former Member
    Mar 29, 2017 at 10:33 AM

    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);

    Add comment
    10|10000 characters needed characters exceeded