What is _SYS_BIC and _SYS_REPO, and their differences?
What is _SYS_BIC and _SYS_REPO, and their differences? And I find it hard to understand all those schemas on SAP HANA System...
Nikhil Joy replied
Both are system users and there schemas are system schemas. Whenever we create a model and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema. Whatever we are modelling in a view cannot be accessible for front end tool like BO directly. They can access only the objects in Catalog section. So only way to get the data by front end tools is query column views in _SYS_BIC.
Whenever we create a model,_SYS_REPO user creates necessary runtime objects from them which get saved into _SYS_BIC schema. After activation _SYS_REPO gives the user read access to the activated models. This is why it is necesary to grant _SYS_REPO with SELECT WITH GRANT previlage to the users schema.
Refer below link to see a very detailed explanation from Lars on _SYS_REPO.
And if you are wondering why we need all these specific schemas, i think the answer would be, with the help of these system schemas, authorization and data management happen in SAP HANA.