How to get the encrypted passwords in 11g
This is what I use to get the encrypted passwords in 11g: col name format a10 col DEFAULT_PASSWORD format a17 col status format a17 select u.name,m.status,u.password PASSWORD from sys.user$ u, sys.user_astatus_map m where u.astatus = m.status# order by 1;