CODEWITHSUNDEEP
hana
Hari Shankar
Hari Shankar

Reputation: 13

not able to to call function inside stored procedure in SAP HANA

In HANA I have created a function in a schema called A. I am trying the use the function in procedure. While trying to activate the procedure I am getting error message insufficient privilege: Not authorized. But when I am running in SQL console I am getting the result. Please help to solve this issue

Upvotes: 1

Views: 3411

Answers (1)

Lars Br.
Lars Br.

Reputation: 10396

You seem to be mixing a catalog object ( your DATE_CHECK function) with a design time procedure. In order to activate your design time object, the repository user _SYS_REPO needs to be able to access the referenced objects and grant access to them.

So by 

GRANT EXECUTE ON a.date_check TO _SYS_REPO with grant option

you should be able to fix that and to activate the design time object afterwards.

Upvotes: 2

Related Questions