Call Procedure authorization error in SQL Console in SAP HANA

[abdul_hakim]

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

[former_member183326]

Hello,

Please see this guide will which instruct you with this error:

https://blogs.sap.com/2015/10/11/troubleshooting-sap-hana-authorisation-issues/

Run the trace to see what you are missing

[KodandaPani_KV]

try the below syntax also

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

Thanks,

Phani.

[KodandaPani_KV]

Hi,

give access to "_sys_repo" user

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

[david_liu1]

Hello,

Check discussions and see if it helps:

http://archive.sap.com/discussions/thread/3688301

http://archive.sap.com/discussions/thread/3688298

Regards,

David

[darshansomaiah1]

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.

[former_member224444]

Hi Hakim,

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

Thanks,

Rithika