What do you need in a multitenant database container (MDC) system to run queries across tenant databases? (Choose two.)
What do you need in a multitenant database container (MDC) system to run queries across tenant databases? (Choose two.)
To run queries across tenant databases in a multitenant database container (MDC) system, you need to ensure that the user in the source system is associated with a user in the target database. This association, often known as a remote identity, is crucial because the associated user in the target database will execute the query and their authorization is checked. Additionally, cross-tenant database communication must be explicitly activated as it is not enabled by default and requires configuration.
In HA200 page 465 Answer is A and D
HA200 SAP HANA 2.0 SPS06 - Installation and Administration. Activation of Cross-Tenant Database Access To access a cross-tenant database, the following must be activated: ●Turn on cross-tenant database communication (run this from SYSTEM database only) ●A user in the target database can only be associated with one user in the source database.
Answer is A and D. A user in one database can run a query that references objects in another database, if the user is associated with a sufficiently privileged user in the remote database. This associated user is called a remote identity. This is the user who executes the query (or part of the query) in the remote database, and therefore the user whose authorization is checked. Cross-database access is not enabled by default and must be configured before such user mappings can be set up.
C. The user in the source system must have sufficient privileges in the target database. D. The cross-tenant database communication must be explicitly activated. To run queries across tenant databases in a multitenant database container (MDC) system, the user in the source system must have sufficient privileges in the target database. The MDC system must allow cross-tenant database communication, which is typically explicitly activated through configuration settings or other means. It is not necessary for the user in the source system to be associated with a user in the target database or for the bidirectional communication channel to be whitelisted
Answer is A and D, the user in the source system must be associated with a user in the target database. The association is Unidirectional and only the SELECT privilege of the target database user are considered.