select dbms_Metadata.get_ddl('USER','...') FROM DUAL;
SELECT DBMS_MetaDATA.GET_GRANTED_DDL('ROLE_GRANT','...') FROM DUAL;
SELECT DBMS_MetaDATA.GET_GRANTED_DDL('SYSTEM_GRANT','...') FROM DUAL;
SELECT DBMS_MetaDATA.GET_GRANTED_DDL('OBJECT_GRANT','...') FROM DUAL;
SELECT DBMS_MetaDATA.GET_granted_DDL('TABLESPACE_QUOTA','...') FROM dual;

然后只需将用户名替换为您要创建的新用户名.