on 02-18-2016 3:28 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.