Python Forum
Missing Privileges to execute a query on SAP HANA thorugh pyhdb
Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Missing Privileges to execute a query on SAP HANA thorugh pyhdb
#1
Hi guys!

I'm trying to execute a simple query by using pyhdb.

Here is my code:

import pyhdb as db

HDB_TRACE=1

db.tracing =True

connection = db.connect('HOST',31047,'USER','PASSWORD')

cursor = connection.cursor()

cursor.execute("SELECT TOP 1 GLOBAL_BRAND_OWNER FROM _SYS_BIC.LAV_DWH_SELLOUT.CV_NIELSEN")

print(cursor.fetchone())

The error I get is pyhdb.exceptions.DatabaseError: insufficient privilege: Not authorized

Do you think it's due to an error in the sintax, or I am really missing some privileges?

I asked to the DB Admin and he told me that the user I'm logging in with has every possible privilege.

If I execute the query thorugh Hana Studio with the same user, it works.
Reply


Messages In This Thread
Missing Privileges to execute a query on SAP HANA thorugh pyhdb - by agrella - Apr-20-2018, 10:43 AM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020