Search notes:

Oracle: DBA_SYS_PRIVS

dba_sys_privs shows system privileges granted to users and roles.

This view comes in the two variants dba_sys_privs and user_sys_privs.

Show privileges for a given role or user:

select
   privilege,
   admin_option
from
  dba_sys_privs
where
  grantee = 'RNYFFENEGGER';

See also