Skip to Content

insufficient privilege exception: insufficient privilege: Not authorized in HCP trial for Web IDE tutorial

Hi,

I am new to HANA cloud platform and Web IDE,

I am following the the tutorial SAP HANA XS Web IDE Tutorial for creating the SAP HANA Cloud Platform E2E Development Scenario: PersonsList Application in SAP HANA XS.

I am following using HANA cloud platform trial version. The application creates the content in

SAP HANA Schema:

_SYS_BIC.


In step14 of the tutorial,In order to view the tables created in the above mentioned schema

it was given to run the SQL command


call HCP.HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS().

But I get the below error while executing the query.


Statement: 'call HCP.HCP_GRANT_ROLE_TO_USER('SIDtrial.myhana.perslist.roles::user','SID')'.Error calling procedure: insufficient privilege: [258] "HCP"."HCP_GRANT_ROLE_TO_USER": line 19 col 11 (at pos 914): [258] (range 3) insufficient privilege exception: insufficient privilege: Not authorized



Also in step 21, I need to assign the role "user.hdbrole" to my user.For that I need to the run the below query.

call HCP.HCP_GRANT_ROLE_TO_USER('<SID>trial.myhana.perslist.roles::user','<SID>')

Statement: 'call HCP.HCP_GRANT_ROLE_TO_USER('SIDtrial.myhana.perslist.roles::user','SID')'.Error calling procedure: insufficient privilege: [258] "HCP"."HCP_GRANT_ROLE_TO_USER": line 19 col 11 (at pos 914): [258] (range 3) insufficient privilege exception: insufficient privilege: Not authorized



Searched a couple of threads,but could not get the correct information, Please suggest me how to add the required previleges & authorizations,Please suggest me to the correct forum if this is not the required forum.


Regards

Veera

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2014 at 12:35 PM

    Hi Veera,

    Follow these steps

    1) Install eclipse studio on your local machine.

    2) Add your HCP trial account in eclipse systems and then run the same SQL

    CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

    3) It will get executed successfully. Then you can resume to SAP HANA web IDE

    By following above steps we are running the SQL via Eclipse rather than SAP HANA WEB IDE.

    For installing SAP HANA tools for eclipse use below link

    SAP HANA Cloud Platform

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2014 at 03:44 PM

    Hi Veera,

    I face this issue some times too.

    Although not sure what the issue could be it generally works from Eclipse

    Follow the blog below to add HANA Cloud Instance to HANA Studio

    8 Easy Steps to Develop an XS application on the SAP HANA Cloud Platform

    Looks mostly to be issue with session as mentioned in Step 1


    temp.JPG (70.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.