on 08-04-2020 11:35 AM
After connecting SAP HANA to Power BI , only SYSTEM user can connect and every time i want to display the data from SAP HANA to power BI i get this Error message :
error old DB or odbc [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] general error : 258 insufficient privileges
Note that the system user has all the privilege
Hi Aladin,
258 is a generic message. Is this the full message? We would expect an object (TABLE, VIEW, SCHEMA) returned as well.
You may assume that HANA is correct and that the user does not have the required privilege(s). Although the SYSTEM user has all built-in system privileges granted, it does not have many object privileges. When you create a table in your schema, SYSTEM will not have access for example.
Latest SAP HANA releases return a GUID, which makes it easy/ier to find out the cause
Otherwise, you can enable tracing to find out how to solve this issue.
This wiki shows an example for 258 on Tableau which may resemble your situation
Enable trace
alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','authorization')='info' with reconfigure;
Run command
alter system alter configuration ('indexserver.ini','SYSTEM') unset ('trace','authorization') with reconfigure;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.