Comparing username with password . . .

piyush mathiya — Sun, 06 Jul 2008 23:35:16 GMT

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

Re: Comparing username with password . . .

melvyn burnard — Mon, 07 Jul 2008 05:58:52 GMT

posted in wrong forum, moved to more appropriate forum

Re: Comparing username with password . . .

Vadim Loginov — Tue, 22 Jul 2008 22:05:53 GMT

Hi,

The link below possibly will be helpful for you:

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

Regards,
Vadim

topic Re: Comparing username with password . . . in Operating System - Microsoft

Comparing username with password . . .

Re: Comparing username with password . . .

Re: Comparing username with password . . .