you need to get the original owner of the schema to grant the select to the new user with GRANTABLE TO OTHERS.
SYSTEM will also fail. SYSTEM is not GOD user, only the owner can grant other users the ability to grant further.
If you look here:
https://blogs.sap.com/2015/10/11/troubleshooting-sap-hana-authorisation-issues/
It states:
Please be aware that if you find that the owner of an object is _SYS_REPO, this is not as straight forward as logging in as _SYS_REPO as this is not possible because SYS_REPO is a technical database user used by the SAP HANA repository. The repository consists of packages that contain design time versions of various objects, such as attribute views, analytic views, calculation views, procedures, analytic privileges, and roles. _SYS_REPO is the owner of all objects in the repository, as well as their activated runtime versions.
You have to create a .hdbrole file which which gives the access ( Development type of role, giving select, execute, insert etc access) on this schema. You then assign this role to the user who is trying to access the object.
I got it to run on this way...
Add comment