I support a database that uses an active dataguard physical standby. The standby database is configured to let users access the read only standby for read only queries and reporting. We do this allow querying of production data, without risking user queries creating problems with locking/blocking.
The one problem with this, is users are unable to reset their own passwords, because they are going given the connection details for the read only database. I am trying to think of a way that would allow the users to reset their own passwords from the read only standby, but I am coming up late. I'm wondering if anyone has dealt with a similar issue has found a work around.
Right now, every time one of the users who only has access to the standby database, has their password expire, they reach out to a member of the dba team and have their password reset manually.
I am trying to find a way to allow users to be, logged into the standby database, but reset their password in the primary copy, without having to give the users the production connection details.