What happens when a User Mapping's Password Changes?

Question

I would like to use a service with our Database, but it doesn't support Amazon RDS IAM Database authentication. My plan is to have a mock-database that only has tables it needs from the original postgres DB, and to have a script that refreshes the service's user's password on the real DB every time it expires (15 minutes).

What happens when I call ALTER USER MAPPING on the Foreign User? Does it reconnect to the server with a new username and password?

Did you try it out? That might provide the answer. – Laurenz Albe Sep 14 '20 at 03:49 — Laurenz Albe, Sep 14 '20 at 03:49

score 1 · Accepted Answer · answered Sep 17 '20 at 06:42

1

Yes, when you change the userid or password using ALTER USER MAPPING, it will reconnect the user. It may wait until the user actually requests something to authenticate, but the user will not know the difference.

answered Sep 17 '20 at 06:42

Steve Benfield

26
3

What happens when a User Mapping's Password Changes?

1 Answers1