Skip to Content
avatar image
Former Member

Getting errors while selecting data preview from attribute view.

Hello!

We are trying to demonstrate a big data use case to one of our customer using HANA and SAPUI5. Though we are certain that HANA is more efficient than our current implementation using NoSQL database, we are not able to demonstrate that effectively because of restrictions on access privileges

I created analytic view and attribute view on _SYS_BIC schema. View uses table from _SYS_BIC scheme schema. I am getting errors while selecting data preview

However, if I try to get to the element from select query and

I receive:  Could not execute 'SELECT * FROM "_SYS_BIC"."p1941009112trial.emchana.emc.views/AT_EROLLMENT_STATUS"' SAP DBTech JDBC: [2048]: column store error: search table error: [2950] user is not authorized.SAP DBTech JDBC: [2048]: column store error: search table error: [2950] user is not authorized

I executed successfully

call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

But this doesn't help.

        Does anyone know what privileges should be assigned to user and how can this be done?

Thanks,

Aniket

sap error.PNG (78.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 05, 2014 at 10:49 AM

    Hi ,

    While defining the views (analytic, attribute, calculation) in hana studio or in eclipse , you just need to disable the Apply Privileges and then you can query the views with out any errors .

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2014 at 06:59 AM

    Hi Aniket,

    I guess you have SELECT access on _SYS_BIC schema.

    Are you using Analytic Privileges for your Views?

    If yes, then create Analytic Privileges for the views and assign them to the User


    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2014 at 08:01 AM

    Hi,

    You need to have SELECT & EXECUTE privilege on _SYS_BIC schema.

    Also need to have CATALOG READ system privilege and CONTENT_ADMIN role granted.


    CONTENT_ADMIN : This role has most vital privileges. It has :

    a. SQL Privileges on Schema _SYS_BIC with GRANT OPTION

    b. SQL Privileges on Schema _SYS_BI with GRANT OPTION

    Regards,

    Prasana

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2014 at 01:54 PM

    Hi Aniket,

    You can have a look at this thread which I've answered

    Best regards,

    Wenjun

    Add comment
    10|10000 characters needed characters exceeded