Skip to Content
0

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

Mar 28, 2017 at 03:31 PM

79

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Michael Plazzer Mar 29, 2017 at 06:14 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Marius Rarinca Mar 29, 2017 at 10:33 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded