This is more of a concept question. I am on a monitoring team and we're currently starting to monitor Oracle Database. The company has a requirement to update passwords every 90 days. We need to monitor 1000s of Databases and do not want to have to go in to all of them and change the password every 90 days.
What is the best way to automate this process? I was thinking of trying to write a python script to connect to the database and then update the password; I know very little about oracle, is that even possible? is there a tool out there that would do something like this?
Looking for some preferred methods or recommendations on how to automate this process.
Thanks
Your requirement is not clear to help in exploring a better solution
Blockquote
I was thinking of trying to write a python script to connect to the database and then update the password
Blockquote
This is valid, if you know the existing passwords (or have DBA access), then you can still do in a loop, given you're updating all to the same password, or have a a way to generate the password using a pre-defined pattern: The command to change password:
alter user <username> identified by <password>
You can use python or any scripting language for the above in a loop once you can connect to user or sys