Skip to Content

Call Procedure authorization error in SQL Console in SAP HANA

Hi,

I am calling Procedure from SQL Console in SAP HANA studio. I am getting the below error.

Could not execute 'CALL "test999.a4h.book.chapter004::DETERMINE_CONNECTION_UTILIZATION" ('600', 'LH', NULL)' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Thanks,

Abdul Hakim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Oct 18, 2016 at 05:20 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 04:56 AM

    Please use "SYSTEM" user id and login to web IDE and provide the roles to your custom DB user id and try to run the procedure.

    Use https://archive.sap.com/discussions/thread/3507480 as reference.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2016 at 04:55 AM

    Hi Hakim,

    It looks like Object privilege issue. Do you have authorization on the package which this procedure is created?

    Thanks,

    Rithika

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2016 at 08:15 AM

    Hi,

    give access to "_sys_repo" user

    GRANT SELECT ON SCHEMA "<YOUR_SCHEMA"> TO "_SYS_REPO" WITH GRANT OPTION;

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2016 at 08:16 AM

    try the below syntax also

    GRANT EXECUTE ON SCHEMA "<YOUR_SCHEMA"> TO "_SYS_REPO" WITH GRANT OPTION;

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded