HANA Table Access

[Former Member]

Hi ,

We are replicating ECC tables to HANA DB using SLT.

We have a business scenario where the power users wanted to access the data directly from these HANA tables.

What are the different options we have to provide them the direct access to HANA tables.

We do not have a HANA studio modeling license so we cant create views and provide them access to those views.

Any inputs will be much appricated.

Regards,

Vishnu

[lucas_oliveira]

Hi,

I honestly would avoid providing access to the tables directly. That kind of scenario is usually not for power-users but most likely for support situations only.

Surely you can set up a role for those power users and allow them to select data from your tables/schema directly and then provide them HANA Studio or the Web interface access.

However, you'd need to pay *extra-special attention* to what kind of access (on which tables/views) you're providing since SQL privileges do not consider row-level access. It's generally *very* dangerous to allow so called 'power users' to check whatever is replicated tables. They might check sensitive information for instance. Imagine payroll...

All in all, there's a reason why we have Analytic Privileges around

BRs,

Lucas de Oliveira

[Former Member]

Once way is, if we have a BW system on top of HANA, we can access HANA tables using the HANA views created on top of them with the help of BW virtual providers. But is there a way we can access these tables directly?

Regards,

Vishnu

[Former Member]

This message was moderated.