-
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.
PMS
-
Hi,
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
Cheers
Fabien
-
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?
PMS
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|