SQL> exec dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'SQLTERMINATOR', true);

PL/SQL procedure successfully completed.

SQL> select dbms_metadata.get_ddl('ROLE',role) from dba_roles where rownum<=3;
DBMS_METADATA.GET_DDL('ROLE',ROLE)
----------------------------------------------------------------------------------------------------

   CREATE ROLE "CONNECT";


   CREATE ROLE "RESOURCE";


   CREATE ROLE "DBA";


3 rows selected.

SQL> select dbms_metadata.get_granted_ddl('ROLE_GRANT',username) 
  2  from dba_users where username!='SYS' and rownum<=2;
DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT',USERNAME)
----------------------------------------------------------------------------------------------------

   GRANT "DBA" TO "SYSTEM" WITH ADMIN OPTION;

   GRANT "AQ_ADMINISTRATOR_ROLE" TO "SYSTEM" WITH ADMIN OPTION;

   GRANT "MGMT_USER" TO "SYSTEM";


   GRANT "RESOURCE" TO "OUTLN";


2 rows selected.

SQL> select dbms_metadata.get_granted_ddl('SYSTEM_GRANT','CONNECT') from dual;
DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','CONNECT')
------------------------------------------------------------------------------

  GRANT CREATE SESSION TO "CONNECT";


1 row selected.

SQL> select dbms_metadata.get_granted_ddl('OBJECT_GRANT','AQ_USER_ROLE') from dual;
DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','AQ_USER_ROLE')
-----------------------------------------------------------------------------------

  GRANT EXECUTE ON "SYS"."DBMS_TRANSFORM" TO "AQ_USER_ROLE";

  GRANT EXECUTE ON "SYS"."DBMS_AQ" TO "AQ_USER_ROLE";

  GRANT EXECUTE ON "SYS"."DBMS_AQIN" TO "AQ_USER_ROLE";

  GRANT EXECUTE ON "SYS"."DBMS_AQJMS_INTERNAL" TO "AQ_USER_ROLE";


1 row selected.