Skip to Content
author's profile photo Former Member
Former Member

I want to have every permission to do modeling in sap Hana ? But I have an problem with sys_bi and sys_bic schema?

AActually .......as I read in modeling PDF of sap Hana provided material...then before doing modeling process...we should have some set of permission...

i Understood all permission except the ....

1._sys_bi.....how should I give select privilege to it....

2. _sys_bic.....how should I give select privilege to it....

And I have readed many contents in scn .....All are discuss about sys_repo,sys_statics ,but no information regarding _sys_bi and _sys_bic...

so so anyone can just explain briefly along with example ....better for me...

THankyou,

jagaa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 05, 2013 at 07:12 PM

    Hi Jagaa,

    If you give your user the MODELING role it automatically will contain privileges for _SYS_BI and _SYS_BIC. Unfortunately it also contains an analytic privilege called _SYS_BI_CP_ALL which essentially gives access to ALL content. If this is too much access you can simply create a new role and assign this role OBJECT PRIVILEGES for _SYS_BI and _SYS_BIC schemas as well as REPOSITORY_REST procedure (execute).

    As far as what they do, when you create views and activate them certain meta data and hierarchy information is stored in these schemas and when you consume the views (ie: in excel mdx or microstrategy or other tool) the user will need access to these in order to access your generated code.

    I hope this helps.

    -Patrick

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jagaa,

      A role is a set of privileges and authorizations. When you open the Role from Roles directory you should be able to see what all privileges this role has.

      As for the other question-.i can see SYS_REPO user ....but no user with name SYS_BI or SYS_BIC? why?....

      _SYS_BI and _SYS_BIC are not Users. whereas _SYS_REPO is a user. _SYS_BI and _SYS_BIC are schemas owned by _SYS_REPO User.

      --

      Shreepad

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.