Skip to Content

HANA Procedure authorisations

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?

Add comment
10|10000 characters needed characters exceeded

  • 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?

  • 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

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 13, 2018 at 04:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded