Our application has public synonyms that should be versioned along with our application, but Source Control for Oracle isn’t picking up the public synonyms that point to objects in our versioned schemas.

Would it be possible to look for public synonyms whose referenced object is in the list of schemas that are in the SC project? For example, if my project schemas were ‘MYSCHEMA1’ and ‘MYSCHEMA2’, then SC for Oracle would look to version any public synonyms with a query like this:

SELECT *
FROM allsynonyms
WHERE owner = 'PUBLIC'
AND tableowner IN ('MYSCHEMA1', 'MYSCHEMA2');

That way, SC can weed out all the public synonyms we're not interested in, ones referring to other schemas like SYS that is, but would still pick up any public synonyms that point to the objects I am versioning in MYSCHEMA1 and MYSCHEMA2.