on 02-26-2014 12:30 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.