show-privs-for-specific-user.sql

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