gazzag wrote:
>>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 :-)
>
I add a "select 'USER='||username from user_users;".
This lets me grep for 'USER=' to clearly show the lines.
Received on Thu May 04 2006 - 14:34:59 CDT
