How to minimize down time when change passwords on replication databases?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to minimize down time when change passwords on replication databases?

  1. #1
    Join Date
    Nov 2000
    Posts
    162

    Lightbulb How to minimize down time when change passwords on replication databases?

    Dear all,

    We have databases on different time zones throughout the country. We have to implement all user passwords change every 60 days. Our databases are multi master replication databases, they are managed by different dba teams with different peak times, down times, and maintenance windows. We want to make sure these password changes are smooth, with minimum to 0 down time, no broken jobs and replications. We are trying to defer job push, change passwords, recreate all db links, schedule job push at the same time throughout our databases.

    Can you advice options of ways we can implement these changes, or if there are tools that will help us to enforce the passwords changes every 60 days without breaking our replication or causing any down time?


    Thanks,
    Unna

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471
    Replication account passwords are not your "regular" users.
    DO NOT change passwords every 60 days, set special profiles for these accounts.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2000
    Posts
    162
    Thanks for your reply. That what we had been doing in the past years, but recently we are required to change passwords for all users in all our databases every 60 days. We have to implement and enforce this rule!

    Any suggestions?

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