Skip to Content
0
Jun 27, 2019 at 05:11 AM

Stored Procedure with Definer in SAP HANA

744 Views

Hi All,

I am creating a repository stored procedure in schema SCHEMA_A logged in as user SCHEMA_A ,in which i am selecting data from SCHEMA_A. The procedure is created with definer rights.

Since it is a repository procedure definer will be SYS_REPO.

So,I have given the SELECT and EXECUTE privilege on SCHEMA_A to user _SYS_REPO.

Now, when i am trying to call this stored procedure logged in as user SCHEMA_A, i am getting "insufficient privileges" error. But i am able to run select query on schema SCHEMA_A

Please provide your inputs on how definer rights work for procedure.

Regards,

Shubham Jain