Aw: Active Data Guard User Password Changes
From: <rogel_at_web.de>
Date: Mon, 12 Sep 2022 19:18:32 +0200
Message-ID: <trinity-97eb1d48-820f-4f9b-a3dc-3350a8b11e52-1663003112013_at_3c-app-webde-bap55>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 12 2022 - 19:18:32 CEST
Date: Mon, 12 Sep 2022 19:18:32 +0200
Message-ID: <trinity-97eb1d48-820f-4f9b-a3dc-3350a8b11e52-1663003112013_at_3c-app-webde-bap55>
Hi Charlotte,
easiest way I can think of is:
- Create a database link master from the standby to the master.
- Write a PL/SQL-procedure with calls "ALTER USER ... IDENTIFIED BY..." via dbms_sql_at_master.
Regards, Matthias
Gesendet: Montag, 12. September 2022 um 19:15 Uhr
Von: "Charlotte Hammond" <dmarc-noreply_at_freelists.org>
An: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
Betreff: Active Data Guard User Password Changes
Von: "Charlotte Hammond" <dmarc-noreply_at_freelists.org>
An: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
Betreff: Active Data Guard User Password Changes
Hello All,
I'm puzzling over how I can most easily allow some (real people) users connected to an Active Data Guard standby database change their own passwords. They are not allowed to connect to the primary (even temporarily).
Does anybody have a simple way to do this?
Many thanks!
Charlotte