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:
you can try to troubleshoot the issue:
- Double-check the user credentials: Make sure that the username and password provided in the connection parameters are correct. Any typos or incorrect credentials can lead to authentication failures.
- Verify the user's privileges: Ask your DB Admin to double-check the user's privileges specifically for the _SYS_BIC.LAV_DWH_SELLOUT.CV_NIELSEN view. Even though the user might have general privileges, it's possible that they are missing the required privileges for this specific view.
- Check the connection details: Ensure that the hostname, port number, and other connection details provided in the connect function are correct. If any of these details are incorrect, it can result in connection failures.
- Confirm pyhdb compatibility: Make sure that your version of pyhdb is compatible with your HANA database version. There could be compatibility issues if the pyhdb version is outdated or not fully compatible with the HANA database version you are using.
- Test with a different query: To isolate the issue, try executing a different query that doesn't rely on specific privileges or views. For example, you can try executing a simple SELECT * FROM <table> query on a table that you have confirmed the user has access to. If this query works, it narrows down the issue to the specific privileges on the _SYS_BIC.LAV_DWH_SELLOUT.CV_NIELSEN view.
- Check for additional error messages: The error message you provided (insufficient privilege: Not authorized) indicates a lack of privileges, but there might be additional error messages or details that can provide more insights into the issue. Make sure to check the complete error stack trace or any additional error messages that might be available.
buran write Jul-10-2023, 07:08 PM:
Advertisment/spam removed
Advertisment/spam removed