Database Users (with last password change date)
select s.name "User", p.granted_role "Role", s.ptime "Password change date"
from dba_role_privs p,
sys.user$ s,
dba_users d
where s.name = p.grantee
and d.username = s.name
and d.account_status = 'OPEN'
order by 1,2,3;