Hi,
I was facing couple of issues while deleting the Discoverere 10g workbook from front end.
I successfully deleted the same from backend.
Please find the scripts to delete particular workbook (select sql - to retrive and confim the workbook name ) and delete sql (pass the parameters as per the outcome/requirement of select statement.
eg:-
1)select * from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
2)select .DOC_NAME,d.DOC_DEVELOPER_KEY,p.notm,d.notm,d.DOC_DESCRIPTION,p.AP_ID,p.AP_TYPE,p.AP_EU_ID, p.GD_DOC_ID,d.doc_id from eul5_access_privs p, eul5_documents d where p.gd_doc_id=d.doc_id and d.doc_id=121412;
3)select * from eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
4)DELETE FROM eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
5)delete from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
6)commit;
Hope this helps.
Don't forget to give your feedback. :-)
Regards
Guru