I have a generic JDBC connection that when I click on the 'Retrieve Schema' button, it is only returning / processing 1 schema. There should be 24. If I call a stored procedure that is ultimately used to retrieve the lists of schema then it returns all the values. Is there anyway to debug this? Log files i can look at or something I can try to see get all the schemas to appear?
I think retrieve schema only display tables/schema you have access with user you logged in.
My user has access to all the schemas - it is a super user.