cancel
Showing results for 
Search instead for 
Did you mean: 

insufficient privilege while having a DATA PREVIEW in an analytical view

Former Member
0 Kudos

Hello all, I'll start telling you how did I get to this problem:

I'm working with Predictive Analysis on top of HANA, so then I tried to run a table (inside HDB), but it only brought me a fell lines in predictive (brought me 20 lines, but the table have more than 27 million lines!)

So then I started a discussion at PA comunity,so Andreas Forster suggested me to create an ANALYTIC View, so then I might could analyse the table. And than I got to this problem: see link whit the role story:

My problem is that when I try to data preview the analytical view, it gives me an error of insufficient privilege. Does anyone knows wich privilege I need to garantee, so then I could preview it?

Regards!

Accepted Solutions (1)

Accepted Solutions (1)

former_member182302
Active Contributor
0 Kudos

what is the exact error message it is showing?

Am expecting that you may have missed granting select on the schema you are working to  _SYS_REPO user

GRANT select on schema <yourschemaname> to _SYS_REPO with GRANT OPTION

Regards,

Krishna Tangudu

Former Member
0 Kudos

Hi Krishna, I executed this comand yesterday and it worked.

but I just can't see the preview.

When i click with the right button at the analytics view I want to preview, it gives me this error:

when I open it, in click first and validate, and then activate, it gives me this error:

then I clicked on yes, and when I try to activate again, it gives the same error.

And when I click in data preview, the same error of insufficient privilege.

And this is the SQL script with the comand:

Regards!

former_member182302
Active Contributor
0 Kudos

please add "with GRANT OPTION"

GRANT SELECT ON SCHEMA "TicketDufry" TO _SYS_REPO WITH GRANT OPTION

Former Member
0 Kudos

Hi, I put that, and then it worked!

I clicked on data preview, and it opened.

But now I got another problem, when I click on the column name I want to, it gives me the following error:

Do you know what might be happening?

Regards!

former_member182302
Active Contributor
0 Kudos

You are getting a numeric overflow error. are you sure that it would generate that a number as big as it is coming.

if you feel that it can cross,then declare a proper data type for that field.

Regards,

Krishna tangudu

Former Member
0 Kudos

Hi Krishna! I changed the data type from one column, and than I could see the data and also open it on predictive analysis!

Thank you so much for your help!

Regards

Answers (0)