Missing Privileges to execute a query on SAP HANA thorugh pyhdb - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: Networking (https://python-forum.io/forum-12.html) +--- Thread: Missing Privileges to execute a query on SAP HANA thorugh pyhdb (/thread-9637.html) |
Missing Privileges to execute a query on SAP HANA thorugh pyhdb - agrella - Apr-20-2018 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. RE: Missing Privileges to execute a query on SAP HANA thorugh pyhdb - zyple - Jul-07-2023 The error message you're encountering suggests that the user you're using to connect to the HANA database does not have sufficient privileges to execute the query. Although your DB Admin claims that the user has all the necessary privileges, there might be some additional steps or configurations required to allow access via pyhdb. you can try to troubleshoot the issue:
|