Oracle Privileged Users and Default Password Audit

SELECT grantee, granted_role, admin_option
FROM   dba_role_privs
WHERE  granted_role IN ('DBA','SYSDBA','EXP_FULL_DATABASE','IMP_FULL_DATABASE')
ORDER  BY grantee;

SELECT d.username, u.account_status, u.profile
FROM   dba_users_with_defpwd d
JOIN   dba_users u ON u.username = d.username
ORDER  BY d.username;

SELECT username, account_status, expiry_date, profile FROM dba_users
WHERE  account_status = 'OPEN' AND expiry_date IS NULL;