Operating System - Microsoft
1747983 Members
4576 Online
108756 Solutions
New Discussion юеВ

Re: 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 2
melvyn burnard
Honored Contributor

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!
Vadim Loginov
Advisor

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