Query to fetch DDL for User including Privileges and Roles Using dbms_metadata.get_ddl

               SET HEADING OFF; SET ECHO OFF; SET PAGES 999; SET LONG 90000;

---------DDL OF USERS--------SELECT DBMS_METADATA.GET_DDL('USER',TB.USERNAME) AS "DDL" FROM DBA_USERS TBWHERE USERNAME NOT IN ('ANONYMOUS','BI','DBSNMP','MGMT_VIEW','XS$NULL','DIP','DVF','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','IX','MDDATA','OE','ORACLE_OCM','ORDDATA','ORDPLUGINS','OUTLN','PM','SCOTT','SH','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','XDB','RMAN','RMAN_BACKUP','SQLTXADMIN','SQLTXPLAIN')AND USERNAME NOT LIKE '%APEX%'AND USERNAME NOT LIKE '%SYS%'ORDER  BY USERNAME ASC
---------ROLE OF USERS------------SELECT 'SELECT DBMS_METADATA.GET_GRANTED_DDL(''ROLE_GRANT'','''||  USERNAME || ''') FROM DUAL;' AS "DDL" FROM DBA_USERSWHERE USERNAME NOT IN ('ANONYMOUS','BI','DBSNMP','MGMT_VIEW','XS$NULL','DIP','DVF','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','IX','MDDATA','OE','ORACLE_OCM','ORDDATA','ORDPLUGINS','OUTLN','PM','SCOTT','SH','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','XDB','RMAN','RMAN_BACKUP','SQLTXADMIN','SQLTXPLAIN')AND USERNAME NOT LIKE '%APEX%'AND USERNAME NOT LIKE '%SYS%'ORDER  BY USERNAME ASC
-------------SYSTEM PRIVILAGES-----------SELECT 'SELECT DBMS_METADATA.GET_GRANTED_DDL(''SYSTEM_GRANT'','''||  USERNAME || ''') FROM DUAL;' AS "DDL" FROM DBA_USERSWHERE USERNAME NOT IN ('ANONYMOUS','BI','DBSNMP','MGMT_VIEW','XS$NULL','DIP','DVF','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','IX','MDDATA','OE','ORACLE_OCM','ORDDATA','ORDPLUGINS','OUTLN','PM','SCOTT','SH','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','XDB','RMAN','RMAN_BACKUP','SQLTXADMIN','SQLTXPLAIN')AND USERNAME NOT LIKE '%APEX%'AND USERNAME NOT LIKE '%SYS%'ORDER  BY USERNAME ASC
-------------------OBJECT PRIVILAGES--------SELECT 'SELECT DBMS_METADATA.GET_GRANTED_DDL(''OBJECT_GRANT'','''||  USERNAME || ''') FROM DUAL;' AS "DDL" FROM DBA_USERSWHERE USERNAME NOT IN ('ANONYMOUS','BI','DBSNMP','MGMT_VIEW','XS$NULL','DIP','DVF','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','IX','MDDATA','OE','ORACLE_OCM','ORDDATA','ORDPLUGINS','OUTLN','PM','SCOTT','SH','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','XDB','RMAN','RMAN_BACKUP','SQLTXADMIN','SQLTXPLAIN')AND USERNAME NOT LIKE '%APEX%'AND USERNAME NOT LIKE '%SYS%'ORDER  BY USERNAME ASC



---------2ND QUERYSELECT dbms_metadata.get_ddl('USER','VVS') FROM dual;SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','VVS') from dual;SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','VVS') from dual;SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','VVS') from dual;




---Also we get that from OEM user ddl