General
cancel
Showing results for 
Search instead for 
Did you mean: 

Comparing username with password . . .

piyush mathiya
Trusted Contributor

Comparing username with password . . .

Hi gurus,
I know that this is unix group, but I have some problem in windows.
We got new project, In that there are x number of databases. In some databases there are more then 3000 database users, I need to check that which user have a same password. As you know that we can not check manually as there are large number of users and number of databases are there.
For example:
set ORACLE_SID = XYZ
c:\> sqlplus /nolog
SQL> conn / as sysdba
SQL> show user
User is "SYS"
conn abc/abc
conn xyz/xyz #where xyz is database user.
I want a script or some smart way to check which user have same password as username.
And I don't have any OS users, and only windows servers.

Thanks & regards,
Piyush Mathiya
2 REPLIES

Re: Comparing username with password . . .

posted in wrong forum, moved to more appropriate forum
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!

Re: Comparing username with password . . .

Hi,

The link below possibly will be helpful for you:

http://www.oracleanalyzer.com/archives/2004/02/managing_passwo.html

Regards,
Vadim