Regarding 2950 user is not authorised -Data preview error

[Former Member]

Hi

Working on HANA SP3 version 24.

Does anyone found exact reason for below error?

Data Preview error:

SAPDBTech JDBC: [2049]:column store error:Search table error: 2950 user is not authorised

Already i have posted in forum but does not solved my problem

http://scn.sap.com/thread/3152671

Appreciate if somebody can tell me exactly whats the cause for this? or narrow down the issue.

for eg, i created attribute view from table, activated view and see data preview, above error is displayed.

Regards

[hai_murali_here]

Hi,

Are you using SYSTEM user or Non System user?

If its Non System user,Just make sure the following

1._SYS_REPO user has your schema added with Select Priv under "SQL Privileges" tab

2.For the Non System user,add _SYS_BI and _SYS_BIC with all privileges under "SQL Privileges" tab

3.Make sure you added MODELING Role for the Non System user(if you have this, step no 2 is not needed)

Rgds,

Murali

[Former Member]

Hi Murali

I am using Non-System User(HUSER1), and I have done below 2 steps already.
But still error exists.

In addition i noticed in SQL Privilege for HUSER1, that Schema is granted by HUSER1 itself with SELECT - NO option.
when i try to change SELECT privilege for YES for Schema, it says grantor and grantee are identical error.
Also If i try to change this using SYSTEM user, Schema privilege option is greyed out, i cannot change it.

Anything missing? above change is must?

I wonder why SYSTEM user also cannot change it, any particular privilege is missing for SYSTEM user?

Pls advice

Regard

[hai_murali_here]

Hi,

You no need to add the schema to your user.

If you are the owner of the schema,Open the sys_repo user through your user and add the schema with select priv under SQL Priv

If you face any issues,revert me.

Rgds,

Murali

[Former Member]

Hi Murali

Thanks for reply.

Yes in that case, i checked all privilege for Schema including Select with grantor TUSER1 in SQL priv.

but still error exists.

Any other place to check?

Regards

Chandra

[hai_murali_here]

Hi,

Did you add _SYS_BI and _SYS_BIC to your user with all priv under SQL Priv which I mentioned earlier.

Rgds,Murali

[Former Member]

Hi Murali

yes i have added it to user HUSER1 using SYSTEM as Grantor

For _SYS_BI, CreateANY, Alter, drop privileges cannot be checked. otherthan its checked.

Even i can send you the image as attachment. where i can attach for u?

Regards

[hai_murali_here]

Hi,

Just through discussions,I couldnt find what is the root cause for this issue.

Is it possible for you to provide a document with step by step with screenshots.So that we can narrow down the problem.

Rgds,

Murali

[Former Member]

Hello Muruli

I solved this error, by creating new Analytic privilege for the Analytic view

and adding that Analytic privilege to User by SYSTEM user.

But one thing i dont understand is, data preview for analytic view was displayed before even without adding analytic privilege.

Could not point out the reason.

Any idea from your side.

Regards

Chandra

[hai_murali_here]

Hi Chandra,

May be your user might be having SYS_BI_CP_ALL Analytic Privilege already added.If this is the case,it will show the data preview for a particular view.But that time the data wouldnt have restricted.

Rgds,

Murali