Skip to Content
0

Call Procedure authorization error in SQL Console in SAP HANA

Oct 18, 2016 at 01:44 AM

225

avatar image

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

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

David Liu
Oct 18, 2016 at 05:20 AM
0
Share
10 |10000 characters needed characters left characters exceeded
Nachappa S Oct 18, 2016 at 04:56 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Rithika Kameshhwaren Oct 18, 2016 at 04:55 AM
0

Hi Hakim,

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

Thanks,

Rithika

Share
10 |10000 characters needed characters left characters exceeded
Phani KV Oct 19, 2016 at 08:15 AM
0

Hi,

give access to "_sys_repo" user

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

Share
10 |10000 characters needed characters left characters exceeded
Phani KV Oct 19, 2016 at 08:16 AM
0

try the below syntax also

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

Thanks,

Phani.

Share
10 |10000 characters needed characters left characters exceeded