Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reposritory Schema access to _sys_repo

Hi Experts,

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: [258]: insufficient privilege: [258] <schema_Name>.<Procedure_Name>: line 8 col 2 (at pos 127): [258] (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.

Could not execute 'GRANT SELECT ON SCHEMA' - insufficient privilege: Not authorized

Please help provide your valuable inputs how to resolve this issue.

Thanks

-Rakesh

Tags:
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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question