The owners of our Teradata database force a password change every 60 days. I help manage a production login that runs many processes. The problem is that when we are in the middle of changing the password, someone or something that has access to the login locks it out during our process. We have to then wait to get the managing entity to get someone to unlock it for us before we can proceed. We have MANY places that the password must be changed. Including, DTS/SSIS packages that have to confirm a connection in the package in order to save it.
My question is: Is there a way to restrict the login so that no one can actually attempt a connect while we are in the process of updating the password in all our packages, files, tables, etc.? The thought was to disable the account, but won't that cause an issue with the DTS/SSIS packages confirming the connection?