cancel
Showing results for 
Search instead for 
Did you mean: 

Getting errors while selecting data preview from attribute view.

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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 .

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Aniket,

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

Best regards,

Wenjun

former_member213376
Participant
0 Kudos

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

vivekbhoj
Active Contributor
0 Kudos

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