Sample Header Ad - 728x90

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