Unable to execute the SQL Procedure from SQL Console

[babu_kilari4]

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

[SergioG_TX · Accepted solution]

Babu,

try adding this into your role.

sql object <YOUR_PROC_PATH> : EXECUTE;

hope it works

[babu_kilari4 · Accepted solution]

Thank you Sergio. That helped. I could execute the SQL Script via the console now.

Cheers

Babu Kilari