This could be an enhancement request as well as a “How do I…”
I would like to be able to RE the PUBLIC synonyms for the objects (tables, packages, etc) that belong to the schema I am REing.
These are accessed by SELECT * FROM ALL_SYNONYMS WHERE OWNER=‘theowner’ OR TABLE_OWNER=‘theowner’;
As far as I can see I only get these if I deselect “Load Proc …Only from Users…of Selected Tables”. If I uncheck this I get loads of other items for the other schemas that I do not want.
I tried altering the SQL query in PreloadSynonyms() and LoadSynonyms() but I now get a failure in CorrectSelection().
I’m stuck now … can you give me some ideas?
May be for an enhancement you could extend the OTP for synonyms to have a “Load Public” extended value or sub item.