Error dberror(Connection.prepareCall): 258 - insufficient privilege: Not authorized

[vangelis_sanchoyerto]

In the hana default App cockpit login page when clicking the Login button after inserting the correct credentials it gives the following error:

dberror(Connection.prepareCall): 258 - insufficient privilege: Not authorized 

The url to access this webapp is:

http://192.168.10.221:8000/sap/sbo/portal/?site=/sap/sbo/cockpit/index.html

We checked the privileges and seemed fine, even did an authorization trace (

https://blogs.sap.com/2015/08/14/how-to-setup-hana-authorization-trace/

) and there were no traces for this error so it seems the error is in another level/part...

The related SAP HANA Tutorial is:

Introduction to the App Framework for SAP Business One, version for SAP HANA

Login Service of the App Framework

Our system is a SAP HANA 9.2 PL9.

[Trinidad · Accepted solution]

Hi Vangelis,

For the login problem with B1 xApp Framework the only requirement should be to add the Object Priviledges for SBOCOMMON and your company DBs schemas.

I had this problem sometime ago and solved it by adding SBOCOMMON to my user. Can you please test it and let me know?

Regards,
Trinidad.

[vangelis_sanchoyerto · Accepted solution]

Well after our systems guy installed the Load Balancer for Service Layer and restarted the server now it enters fine without touching the privileges of HANADBS and other users that previously failed....So I will mark this answer as correct and bring it back if it fails again with this error....

Thanks,

Vangelis