Skip to Content

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 10, 2013 at 01:35 PM

    Hi Angel,

    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.


    Nikhil Joy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.