Reposritory Schema access to _sys_repo
We have created a schema(.hdbschema file) in repository. We have created few table(.hdbtable) and stored procedure(.hdbprocedure) pointing to same schema. When we are trying to execute any procedure we are getting below error.
Could not execute 'call <schema_Name>.<Procedure_Name> ( )' in 7 ms 97 µs .
SAP DBTech JDBC: : insufficient privilege:  <schema_Name>.<Procedure_Name>: line 8 col 2 (at pos 127):  (range 3) insufficient privilege exception: insufficient privilege: Not authorized
We are trying to assign select on schema to _SYS_REPO with grant option using SYSTEM user, but it is not able to assign, giving insufficient privilege error.
As suggested in below thread, we cannot login with schema name into HANA as this is only a schema. There is no user with the schema name.
Please help provide your valuable inputs how to resolve this issue.
Thomas Jung replied
You don't need to grant anything to _SYS_REPO. _SYS_REPO is already the owner of the schema if you created via HDBSCHEMA. The problem is your user doesn't have access. You need to create a role via hdbrole which contains the access rights to these objects. You then assign this role to the users who need it.