Apr-20-2018, 10:43 AM
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.
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.