select *
from (
  select s.grantee
       ,  1  dummy
       , s.privilege system_privilege
       , lpad(' ',  30 ) granted_role
       , ' ' owner
       , lpad(' ',  30 ) table_name
       , lpad(' ',  30 ) object_privilege
       , s.admin_option
       , 'grant '||s.privilege||' to '||s.grantee
         ||decode(s.admin_option, 'YES', ' with admin option')||';' code
  from dba_sys_privs s
  union
  select r.grantee
       ,  2  dummy
       , ' ' system_privilege
       , r.granted_role
       , ' ' owner
       , ' ' table_name
       , ' ' object_privilege
       , r.admin_option
       , 'grant '||r.granted_role||' to '||r.grantee
         ||decode(r.admin_option, 'YES', ' with admin option')||';' code
  from dba_role_privs r
  union
  select t.grantee
       ,  3  dummy
       , ' ' system_privilege
       , ' ' granted_role
       , t.owner
       , t.table_name
       , t.privilege object_privilege
       , null admin_option
       , 'grant '||t.privilege||' on '||t.table_name||' to '||t.grantee
         ||decode(t.grantable, 'YES', ' with grant option')||';' code
  from dba_tab_privs t
)
where  1 = 1 
  and grantee = user
order by  1 ,  2 ,  3 ,  4 ,  5 ,  6