If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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';"