Skip to Content

AMDP problem. SQL message from the database: "insufficient privilege: Not authorized"

Hi all,

Just before running my AMDP via SE24, i get this error ;

SQL code of the database: 258 SQL message from the database: "insufficient

privilege: Not authorized"

Everyting is working fine in development envrionment but it keep failing on production after transport.

I give all select/execute authrozation to my SAPXXX user and _SYS_BIC schemas but still failing,

here is the trace file;

27542]{463464}[537/-1] 2015-12-14 16:24:35.637787 i Authorization SQLFacade.cpp(01222) : UserId(150731) is not authorized because invalid privilege 27 on ObjectId(6,0,oid=5137569)

[27542]{463464}[537/-1] 2015-12-14 16:24:35.637862 i Authorization SQLFacade.cpp(01750) :

schemas and objects in schemas :

SCHEMA-150732-SAPXXX : {CREATE_PROCEDURE} , {}

SCHEMA-139816-_SYS_BIC : {} , {EXECUTE}

PROCEDURE/FUNCTION-5137569-ZPROCEDURE_TEST : {EXECUTE} , {}

[27542]{463464}[537/-1] 2015-12-14 16:24:35.637888 i Authorization query_check.cc(03287) : User SAPXXX tried to execute 'create procedure

"ZPROCEDURE_TEST=>RUN"

language sqlscript sql security invoker as begin

call "_SYS_BIC"."ZPROC_TEST"(:I_VAL);

end; '

i checked the object from OBJECTS table and it is under_SYS_BIC schema.;

Select * from objects where object_oid = '5137569'

Which authrozation do i need to give ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 14, 2015 at 03:37 PM

    after trying total 21512312 number of combinations finally i did by executing

    GRANT CREATE ANY ON SCHEMA SAPXXX TO _SYS_REPO WITH GRANT OPTION


    NOTE TO HISTORY:

    Logged with : SAPXXX user

    Executed under SYSTEM schema.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2015 at 03:18 PM

    Hello Bilen,

    does your SAPXXX user have the rights to create procedures in the "ABAP" schema?

    When a new or changed AMDP is executed a procedure is created for it in the "ABAP" schema.

    According to the messages it seems, that the user does not have the rights to create the procedure.

    Best Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.