I was needing to extract DDL for all roles on Oracle Database . Then, I took the information about it using a DBMS_METADATA. Thus, follow how to take this information: SQL> set heading off; SQL> set echo off; SQL> set pages 2000 SQL> set long 99999 SQL> spool ddl_roles.sql SQL> select dbms_metadata.get_ddl('ROLE', ROLE) from dba_roles; ##HERE WILL BE SHOW ALL ROLES DLL ABOUT YOUR DATABASE## SQL> spool off I hope this post can help you! See ya, Bruno Reis. brunors