> Why not do this:
>
> spool test_password.sql
> SELECT 'CONNECT '||username||'/'||username FROM dba_users;
> spool off
> spool test_password.out
> @test_password
> spool off
>
> This will attempt to connect to every user with the password as their
> username. Review the test_password.out file to see if you were able to
> connect.
This is a good example of how we can sometimes try to over-complicate
things; the simplest solutions are invariably the best :-)
Received on Thu May 04 2006 - 08:42:26 CDT
