DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Changing Passwords

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    30
    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

  2. #2
    Join Date
    Apr 2001
    Posts
    107
    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

  3. #3
    Join Date
    Dec 2000
    Posts
    40
    Can the database level triggers help in synchronizing the passwords????



  4. #4
    Join Date
    Jun 2001
    Posts
    30
    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
  •  


Click Here to Expand Forum to Full Width