Skip to Content
0
Jun 21, 2016 at 09:07 PM

Unable to execute the SQL Procedure from SQL Console

103 Views

Hello HANA Experts,


I am facing the following error with my SQL Script when I tried executing the same from SQL console.

CALL WORKSHOPX_00."workshop.sessiona.00.models::get_bp_addresses_by_role_sql"(partnerrole => '02', bp_addresses => ?);

Error as shown below

Could not execute 'CALL WORKSHOPX_00."workshop.sessiona.00.models::get_bp_addresses_by_role_sql"(partnerrole => '02', ...' in 222 ms 810 µs . SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

My user id has the authorization role as shown below and it does have the necessary schema and SELECT authorization on it.

WorkshopAdmin role has the following text

role workshop.sessiona.00.data::workshopAdmin

extends role workshop.sessiona.00.data::workshopUser

{

catalog schema "SAP_HANA_EPM_DEMO": SELECT, INSERT, UPDATE, DELETE, DROP;

catalog schema "WORKSHOPX_00": SELECT, INSERT, UPDATE, DELETE, DROP;

catalog schema "_SYS_BIC": SELECT;

application privilege: workshop.sessiona.00::Admin;

}

Please let me know if I am missing something ?

Thanks & Best Regards,

Babu Kilari

Attachments

Capture.JPG (27.4 kB)