Our Databases require logins every 30 days. I literally have 100's of connections. We must reset our application and user passwords every 90 to 180 days. I use TOAD every day, at least an hour a day. I would like scripts to do the following
1. Log in, SELECT * FROM DUAL;, then exit for all the TOAD connections.
2. based on criteria, reset the password to all the connections as a bulk reset.