Re: Differentiating between results of getSchemas()

Not exactly. I hope that I understand the difference between a catalog
and schema. Isn't it normal to have "users" that have no tables/views?
User A, for example, may have read-only access to a schema B. User A
has no tables or views, just access rights and related details.

The problem that I'm trying to solve in SchemaSpy is when someone runs
the tool and it can't find any tables/views in the schema that they've
specified. In that situation SchemaSpy displays a list of all of the
available schemas. That list can be massive because logical users are
indistinguishable from "real" schemas that contain tables/views.

I've modified SchemaSpy to display all of the schemas that exist as
well as the subset of those that actually contain tables/views that the
specified user can see. It'll appear in the next release of the tool.

John
http://schemaspy.sourceforge.net

.