Skip to Content
0
Dec 12, 2022 at 05:30 PM

Roles needed in SAP HANA for Tableau user to read from Calculated Views

176 Views

Hi,

We're having trouble defining a user in SAP HANA which has Read only access to Calculated views in SAP HANA.

The Calculated views are created in a package in _SYS_BIC and are pointing at a virtual table (from SDA) in another schema.

We can log into Tableau and view the schema and access the calculated views but when i click "Update Now" on the Datasource, i get the error below.

Unexpected Error

SAP DBTech JDBC: [258]: insufficient privilege: [2950] user is not authorized :

Error Code: B19090E0


Can anybody help with listing the roles / privileges that tableau user needs in HANA database.

Thanks,