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;

Leave a Reply

%d bloggers like this: