SELECT grantee, granted_role AS granted FROM dba_role_privs
WHERE granted_role IN (SELECT grantee FROM dba_sys_privs
WHERE PRIVILEGE = 'ALTER USER')
UNION ALL
SELECT grantee, PRIVILEGE
FROM dba_sys_privs
WHERE PRIVILEGE = 'ALTER USER';