SQL Developer

Hey guys,

New member and I need some help here. We have a development enviroment that my company does not fully control we simply have 2 accounts that we can log into to do any problem solving or changes. This db is refreshed from the production enviroment DB on a weekly basis.

Within the two db's we have a view that uses a read only link to another remote DB that we also dont have access to. This view is flawed and we need to add a few outer joins in the query to pull all the correct info but since we cannot change it in the production enviroment we have to change it in the development since this is the only DB that we can make changes to without waiting the 6 months or a year for the next software patch to be deployed.

SO, I have written a bat file on our server that executes weekly, this batch file calls a sql script, logs into the development DB and updates the view to add the outer joins that are needed. Since the development enviroment frefreshed every week I have scheduled this to run weekly so that each week the view is updated. However the problem I am running into is this.

The password that is used to login to development DB expires weekly, so each week someone has to manually log into SQL+ and make the new password, then update the script with that password or the scheduled job never completes because it is waiting for the password change.

My question is this, is there a way that I automate the password change. So that when the script is called it attempts to login and is given the new password automatically and then logs in? We cant change the password to not expire because again we dont control the DB. Basically I need to find a way to reset an expired password in a script without an user input.

Any Ideas ?