HANA Procedure authorisations

[Rushikesh_Yeole]

Hi all,

I have created procedure/table function under schema SYSREPO and fetching data from table present in schema SAPABAP1. The same will be called in graphical calculation view.

I am getting authorisation error on that select query while debugging.

SYSREPO has complete object privileges for SAPBAP1.

I have tried below statements but getting authorisation error.

GRANTSELECTONSCHEMA"SAPABAP1"TO"_SYS_REPO"WITHGRANTOPTION;

GRANTSELECTONSCHEMA"_SYS_REPO"TO"SAPABAP1"WITHGRANTOPTION;

Sever Trace file shows the same.

I have gone through thread

https://archive.sap.com/discussions/thread/3483015. Please let me know which privileges needs to be assigned to user?

[pfefferf]

What user you are using to execute your procedure?

Are invoker or definer privileges checked for the procedure?

Did you create the procedure by a CREATE PROCEDURE statement directly or via a design time artifact?

[Rushikesh_Yeole]

Thanks..I am using Invoker rights and created via wizard. I am using system User. I have tried to change Default schema also but same error.

PROCEDURE"_SYS_REPO"."public.sap::Test" ( )

LANGUAGESQLSCRIPT

SQLSECURITYINVOKER

DEFAULTSCHEMA"SAPABAP1" -----tried changing

READSSQLDATAAS

[pfefferf · Accepted solution]

As you are using user "SYSTEM" to execute your procedure (as you have written in the comments) and the invoker privileges are checked, the SYSTEM user needs the privilege to execute the procedure and the object privileges (select privileges) on the schema or tables.

Regards,
Florian