Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Operating System - Microsoft
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