Hana Cross_database troubleshot

[Former Member]

Hi all,

I have some probleme with Hana Cross_Database_access in a multitenant system.

I already configured "cross_database_access" in "global.ini" configuration and crate "targets_for_<database_name>" parameter, create a user in both tenant with "remote identity" privilages and grant "select" access in one table in a schema.

But when I try to do a sql statement in target tenant, I always have an error message like this:

"Could not execute 'SELECT * FROM "HC1"."EFASHION_TUTORIAL"."ARTICLE_COLOR_LOOKUP"'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized"

Could anyone help me?

Thanks

[former_member182967 · Accepted solution]

Hello Shahab,

Do you set enable to true under cross_database_access? Make sure the search direction is correct and user in target tenant has the right for selecting.

Please check this step-by-step cross database access in MDC

And then try to select one table from user in target tenant db.

Regards,

Ning

[Former Member · Accepted solution]

Hi,

Thank you for your help.

I already did all these steps but my problem is not solved!

[former_member182967 · Accepted solution]

Hi Shahab,

Please check this note 2266558 - SAP HANA MDC - "not authorized" errors for cross-database queries.

However, currently no workaround for this issue. Until a correction is available cross-database queries cannot be used between the involved tenant databases.

Regards,

Ning Tong

[Former Member · Accepted solution]

Thaks a lot.

I have a Tenant whitch is migrate from a simple contenant Hana.

I'm just trying to create 2 new tenant and do some tests on theses ones and it works.

I must export and import my datas from the old tenant to another.