How to define federated access from IBM Db2 database to another IBM Db2 database without password?
1
vote
1
answer
105
views
On IBM Db2 v11.5.8.0 on Linux x86_64 I have two local databases DB01 and DB02. Both databases individually are configured to use LDAP authentication.
Now I am required to setup a federated access from DB01 to DB02.
Looking at CREATE SERVER and CREATE USER MAPPING there is always definition of userid and password.
I don't know the userid and password for our users (at least I don't know passwords).
Is it possible to define federated access without specifying userid/password at CREATE SERVER and/or CREATE USER MAPPING?
What I would like is that database:
- passes authentication (userid/password) from DB01 to DB02 or
- database does not perform authentication for federated users, because authentication was already made when user connected to DB01 or
- something similar, but without me required to define userid/password for every user in CREATE SERVER or CREATE USER MAPPING command.
Regards
Asked by folow
(523 rep)
Nov 20, 2024, 01:49 PM
Last activity: Nov 21, 2024, 08:34 PM
Last activity: Nov 21, 2024, 08:34 PM