SAP Hana Catalog user Managment (Strategy)

[former_member376663]

We have a Project where we leverage HANA reporting capabilities and developed Calculation views , Catalog views on top of the catalog tables .
These tables and Catalog views were initially created by "SYSTEM" ID and that worked well until now . Now the Audit has mandated us to no longer use
SYSTEM ID . Now if we create a view using any other ID , view gets created but End users are not able to access that view . What we understood from the issue
is that both view and table should have the same owner to properly propogate the access when a view is accessed .

Here is how you can recreate issue what we are having:

1.Create Table T1 using SYSTEM id or USERID1
2.Create View V1 using table T1 using different ID: USERID2
3.Ask USERID3 to execute View V1. It will get authorization error.

Question is what is industry standard practice on managing Catalog objects Tables, Views etc. which is sustainable solution in long term ? How other companies are managing their Catalog objects, using which ID ? and How ?

[former_member376663]

Lars,

Thank you for your answer. We do use repository objects in most cases, however there have been situation where our modeler had to use Catalog objects on certain views where we needed right strategy to manage catalog objects correctly. Hoping someone can answer it correctly.