set lines 200
set pages 8000

select *
  from (select 'grant ' || privilege ||
               decode(privilege,
                      'READ',
                      ' on directory "',
                      'WRITE',
                      ' on directory "',
                      ' on "' || owner || '"."') || table_name || '" to "' ||
               grantee ||
               decode(grantable, 'YES', '" with grant option', '"') || ';'
          from dba_tab_privs
         where grantee in ('USUARIO1', 'USUARIO2')
        union all
        select 'grant ' || privilege || ' to "' || grantee || '"' ||
               decode(admin_option, 'YES', ' with admin option') || ';'
          from dba_sys_privs
         where grantee in ('USUARIO1', 'USUARIO2')
        union all
        select 'grant "' || granted_role || '" to "' || grantee || '"' ||
               decode(admin_option, 'YES', ' with admin option') || ';'
          from dba_role_privs
         where grantee in ('USUARIO1', 'USUARIO2'));