Oracle user DDL

To get user DDL in oracle you need to run this statement:


select dbms_metadata.get_ddl('USER', 'JRL') from dual
union all
select dbms_metadata.get_granted_ddl( 'ROLE_GRANT', 'JRL') from dual
union all
select dbms_metadata.get_granted_ddl( 'OBJECT_GRANT', 'JRL') from dual
union all
select dbms_metadata.get_granted_ddl( 'SYSTEM_GRANT', 'JRL') from dual
union all
select dbms_metadata.get_granted_ddl( 'SYSTEM_GRANT', 'JRL') from dual;