Skip to Content
0
Jul 16, 2015 at 01:46 PM

Issue with Privilege

24 Views

Experts,

When I was trying to build an XSJS application on HCP (trial version) using this http://scn.sap.com/community/developer-center/cloud-platform/blog/2013/10/17/8-easy-steps-to-develop-an-xs-application-on-the-sap-hana-cloud-platform and was trying to run the XS application, I got below error message 😢 😢

Error while executing query: [dberror(Connection.prepareStatement): 258 - insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2422]

While searching solutions in this SCN, I got a number of similar threads on this regard ( 😈 ) , and tried to address by adjusting below files

1. .xsprivileges

{

"privileges" :

[

{ "name" : "Basic", "description" : "Basic usage privilege" },

{ "name" : "Execute", "description" : "Basic execution privilege" }

]

}

2. model_access.hdbrole

role xxxxxxtrial.hanainstancesom.ProjectA::model_access {

application privilege: xxxxxtrial.hanainstancesom.ProjectA::Basic;

application privilege: xxxxxtrial.hanainstancesom.ProjectA::Execute;

catalog schema "NEO_5HEFUYKK25VF3EPY5G0LLNJ5F": SELECT, EXECUTE;

catalog sql object "_SYS_BIC"."xxxxxtrial.hanainstancesom.ProjectA/SO_CV": SELECT;

sql object xxxxxtrial.hanainstancesom.ProjectA:SO_CV.calculationview : SELECT;

}

and finally granted the roles to my user (account user), by executing following code in SQL Console itself

call "HCP"."HCP_GRANT_ROLE_TO_USER"('xxxxxxxtrial.hanainstancesom.ProjectA::model_access','xxxxxxxtrial');

Still, no luck!!!

Can anyone provide solution on how to fix the above issue?

Warm Regards

Som