Error in DATA perview of Attribute views (JDBC Error)

[Former Member]

Hi Experts,

Error Executing Query: SAP DBTech JDBC: [258] (at 69): insufficient privilege: Not authorized: line 1 col 70 (at pos 69)

Any idea on how to overcome this Error.

What authorization am i missing?

Thanks

[tomas-krojzl]

Hello,

you need to have select access to source tables + you might need analytic privilege.. it is hard to say what is missing...

can you give us more details?

Tomas

[Former Member]

Here are more details

Generated Data Preview Query: SELECT TOP 200 "CATEGORY","FAMILY_NAME","ARTICLE_ID" FROM "_SYS_BIC"."i065360/AT_ARTICLE"

Error Executing Query: SAP DBTech JDBC: [258] (at 69): insufficient privilege: Not authorized: line 1 col 70 (at pos 69)

[tomas-krojzl]

Hello,

what exactly is the definition of this attribute view - please list the source tables?

can you select from every table used as source in definition of attribute view?

can you try to define new analytic privilege and grant it yourself?

Tomas

[Former Member]

There is only in table in this attribute view: ARTICLE_LOOKUP

a. ARTICLE_ID as key attribute.

b. CATEGORY and FAMILY_NAME as attribute.

When i preview data at Table level , i do not have any issues. but same is not working for attribute view.

I am trying example from below pdf file

https://www.experiencesaphana.com/docs/DOC-1138

[tomas-krojzl]

Hello,

did you try to create analytic privilege and granted to yourself?

Also I remember that you needed to have select privilege for SYSBIC granted to SYSREPO (and in case of external application like BOBJ universe also to user).

Tomas

[Former Member]

How to create analytic privilege and granted to myself? which command i should write in SQL editor.

I am trying to preview data in HANA Studio it self.

Edited by: New_K_sap on Nov 21, 2011 4:12 PM

[tomas-krojzl]

Hello,

please see this blog - chapter 11 Using SQL

You need to do this via Studio.

Tomas

[tomas-krojzl]

Hello,

I am now busy playing with updating to SP03 incl rev.21... if analytic privilege will not work - I will simulate to see the minimal requirements...

Tomas

[tomas-krojzl]

Hello,

was this issue resolved? I can see you have different problem in this thread:

If it was resolved - could you please paste here the solution that helped?

(someone else might have similar problem in future)

Tomas

[Former Member]

Hi Tomas,

Above issue was resolved, but not by me, My system admin asked me to execute below command

GRANT SELECT ON SCHEMA <your_schema> TO SYSREPO WITH GRANT OPTION;

, i am assuming , above sql statement might have resolved this issue. but now, i am facing new issue in excel.

Thanks