Script to check for username and password are same

[stecal]

This is a no-brainer script. If you can't figure out how to do something like this, I would suggest doing some homework. Cut and paste the results of the query.

SQL> select 'conn '||username||'/'||username||'@'||name string
  2  from dba_users, v$database;

STRING
---------------------------------------------------------------
conn SYS/SYS@DB00
conn SYSTEM/SYSTEM@DB00
conn OUTLN/OUTLN@DB00
conn NEWUSER/NEWUSER@DB00
conn DBSNMP/DBSNMP@DB00
conn STECAL/STECAL@DB00
conn Scott/Scott@DB00
conn DBAF/DBAF@DB00
conn MIKE/MIKE@DB00
conn MIN1/MIN1@DB00
conn MIN2/MIN2@DB00
conn JONES/JONES@DB00
conn DUMMY/DUMMY@DB00
conn SCOTT/SCOTT@DB00
conn ADAMS/ADAMS@DB00
conn CLARK/CLARK@DB00
conn BLAKE/BLAKE@DB00

17 rows selected.

SQL> conn SYSTEM/SYSTEM@DB00
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn OUTLN/OUTLN@DB00
Connected.
SQL> conn NEWUSER/NEWUSER@DB00
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn DBSNMP/DBSNMP@DB00
Connected.
SQL> conn STECAL/STECAL@DB00
Connected.
SQL>