Auto redirect primary connection to active standby database
19c database/data guard
Goal: Forcing inqiry users to connect to active standby database
Reason: user accounts exist in both primary and standby, and we would like to prevent them from connecting to primary.
We would like to automatically redirect certain user accounts to connect to standby database after they try to connect to primary. We do have a separate service on standby and provided to users, but users may still access to primary.
I am looking for a solution if oracle has a feature to do that or we could even use a trigger to redirect a connection to the standby database service.