How to retire report lists of Discoverer?

SELECT ed.doc_name, eu.eu_username,
       ed.doc_created_date,ed.doc_updated_date
  FROM disc_admin.eul5_documents ed,
       disc_admin.eul5_eul_users eu
 WHERE eu.eu_id = ed.doc_eu_id
   AND eu.eu_username like '%your account%'

UNION
SELECT ed.doc_name, eu.eu_username,
       ed.doc_created_date,ed.doc_updated_date
  FROM disc_admin.eul4_documents ed,
       disc_admin.eul4_eul_users eu
 WHERE eu.eu_id = ed.doc_eu_id
   AND eu.eu_username like '%your account%'
 ORDER BY 1

 

Note:

  For obsolete Discoverer 4.x release, EUL5 is replaced by EUL4 in the above query.