Skip to Content
0
Former Member
May 21, 2016 at 10:19 PM

OData problem: ERROR [SQL-258] insufficient privilege: Not authorized

386 Views

Hi,

I want to simply access a sap hana table via a website and I use the OData service for this. My table is located in a custom NEO schema.

When I run my .xsodata file this page opens:

But when I want to access the table, I get an authorization error:

I already checked this Thread, but i couldnt find a solution there. Maybe you can help me 😊.

Here you can see my project:

Those are the files:

xsaccess:

{

"exposed" : true,

"authentication" :

{

"method": "Form"

},

"cache_control" : "must-revalidate",

"cors" :

{

"enabled" : false

},

"enable_etags" : false,

"force_ssl" : false,

"prevent_xsrf" : true

}

xsodata:

service {

"NEO_85J1WXTGGKNE5N9SVH1UNPDYI"."PRODUCT" as "Adressen"; }

model_access.hdbrole:

role s0015309874trial.xstestin.Gpack.geotabelle::model_access {

catalog schema "NEO_85J1WXTGGKNE5N9SVH1UNPDYI": SELECT, UPDATE, INSERT, DELETE;

}

Thank you in advance,

Leon

Attachments

page1.png (22.1 kB)
page2.png (33.5 kB)
page3.png (19.2 kB)