How to grant read access on a schema to another user in sap hana?
There are different ways to give read access to sap hana schema objects such as tables. The first one is the schema owner giving the privilege access to other users directly or through a role. The other way is to give the right access to _SYS_REPO in relation to a modeler development. Either way, the first drawback in this grant procedure option is the schema owner. The super powerful System user or any administrators cannot grant privilege on schemas unless it is the owner. This could be very tricky if the owner disappears or is not accessible anymore.
Granting read access on sap hana table to other users can be done in an orderly manner with a direct grant select to a role before granting the role to a sap hana user. The role is created at the administration level. The grant select is done at the schema owner level to the role. The owner can give privileges directly to the user but it is not a good idea for administration and security reasons. This is straight forward operation and privileges are available from a precise and defined location entity: The schema owner or an intermediate role.