Collect Database User Metadata information 

Connect to database as administrator and you can use below script to collect any database user metadata information

set echo off
SET LONG 2000000
set pagesize 0
set heading off
set linesize 2000
set feed off
set tab off
set trimout on
set trims on
COL RFILE FORMAT A32000

prompt Create Sequence Skript: Create_user.sql
SET TERMOUT OFF
SET SERVEROUTPUT ON

exec dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'SQLTERMINATOR', true);
spool create_users.sql

SELECT to_char(DBMS_METADATA.GET_DDL('USER', USERNAME)) FROM dba_users where default_tablespace='USERS' and account_status='OPEN' order by username asc;

declare
    no_grant exception;
    role_grants varchar2(255);
    pragma exception_init( no_grant, -31608 );
begin
    for c in (SELECT * FROM dba_users where default_tablespace='USERS' and account_status='OPEN' order by username asc)
    loop
        begin
           role_grants := to_char(DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', c.USERNAME));
        exception when no_grant then
           role_grants := '-- no role grants for user ' || c.username;
        end;
        dbms_output.put_line(role_grants);
    end loop;
end;
/

-- SELECT to_char(DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', USERNAME)) FROM dba_users where default_tablespace='USERS' and account_status='OPEN' order by username asc;

spool off