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;