VIEW: DVSYS.DV$SYS_GRANTEE

Source

View Text - Preformatted

SELECT
      u.username
    , 'USER'
FROM sys.dba_users u
UNION
SELECT
      r.role
    , 'ROLE'
FROM
    sys.dba_roles r

View Text - HTML Formatted

SELECT U.USERNAME
, 'USER' FROM SYS.DBA_USERS U UNION SELECT R.ROLE
, 'ROLE' FROM SYS.DBA_ROLES R