I'm writing an Oracle audit script where I need to find users in a database who have set their passwords to be the same as their username, e.g. dbaadmin/dbaadmin. The query would need to get the list of users in the database & then check if their passwords is same as their respective usernames.
Can anyone help me out with this query?
PS: I'm a Database newbie.