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.
upvoted 2 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
lucho73
11 months, 3 weeks agoLizzyOlivan
1 year, 3 months agoNiubileyeah
1 year, 6 months agoschalke04
1 year, 9 months agoCerthicc
1 year, 8 months ago