SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

[former_member196080]

Hi Guys,

I'm using Hana 30 days trial version and on which I've created new user"epmuser", now when I'm trying to data preview of the demo content(analytical view) in that user it doesn't allow me to data preview.

Its throwing error for insufficient privileges.

Cannot get the data provider outline

SAP DBTech JDBC: [257]: sql syntax error: Error:insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2225

I searched the forums and found I need to grant select, but when I'm granting select to the user its throwing me error again as below.

could not execute 'GRANT SELECT ON SCHEMA sap_hana_epm_demo TO epmuser WITH GRANT OPTION' in 3 ms 55 µs .

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Pls help how to solve this issue.

Thx

[former_member182302 · Accepted solution]

Hi Rubane,

Have a look on the SHINE guide below:

http://help.sap.com/hana/SAP_HANA_Interactive_Education_SHINE_en.pdf

You must assign some roles to your user to be able to see the data:

sap.hana.democontent.epm.roles::admin

Regards,

Krishna Tangudu

[former_member196080 · Accepted solution]

Hi Krishna,

This role has been already assigned and it still desn't works.

Also I'm not able to open any XS demo application on internet explorer.

My webpage heading is showing as Hana login , I'm using port 80.

Pls advise

Thx

[rindia · Accepted solution]

Hi Rubane,

The person who is having access (such as administrator) can grant you the access. If you have the SYSTEM user credentials then you can do self else Please talk to you administrator to grant access.

Regards

Raj

[former_member196080 · Accepted solution]

Hi Raj,

I've access for system user, as this is 30 day trial version on cloudshare platform.

Thanks

R

[rindia · Accepted solution]

Hi Rubane,

For the demo application, first assign the Object privileges to SYSTEM user:

GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE - Execute

REVOKE_ACTIVATED_ANALYTICAL_PRIVILEGE - Execute.

Regards

Raj

[former_member196080 · Accepted solution]

Hi Raj,

I already assigned these privileges to user, pls see below for ex:-

[rindia · Accepted solution]

Hi Rubane,

As suggested by Krishna, please go through the SHINE document step by step.

http://help.sap.com/hana/SAP_HANA_Interactive_Education_SHINE_en.pdf

Regards

Raj

[former_member196080 · Accepted solution]

Hi Raj,

I did but couldn't figure out what is wrong therefore raised question.

It would be great if you can help.

Thx

[former_member196080 · Accepted solution]

Hi Guys,

Thanks looks like my problem solved.

Actually I was missing select priviledge on my schema, which I granted now.

Thanks again.

[Former Member · Accepted solution]

Hi Rubane,

Please can you share the procedure for assigning privilege to your user.

Thanks,

Akhtar