I have to databases, On the remote database users have accounts on the central database with passwords similar on both databases. The password at the remote database has been changed for the user but on the central database the password is not changed.
I want find out if it is possible to change the password on the central database using the values of the password on the remote database without asking the user to give me the new password.
I would also want to find out if there is a better way to implement changing of password so that when a password is changed at the remote database, the changes are effected at the central database.
On your remote database, select username, password from dba_users, and take the values of the password for your user. On the 'central' database,
"alter user XXX identified by values 'VALUES_FROM_REMOTE_DATABASE';"
Hope it helps
Can the database level triggers help in synchronizing the passwords????
I am quite sure about triggers. Can you give me more details on the same? How best can you implement them?