getSchemas() for a user

I've run into a problem with the visibility of schemas to the user. The
user (alex) was created with 'secure access' attribute. Prior to the
creation of the user, a schema (Scribe) was created from SYSADM login
account. Now, DatabaseMetaData.getSchemas() returns a full list of
schemas for SYSADM, and a partial list (sans Scribe) for alex.

In the meantime, I got around this problem by extracting the "name"
field from SYS_INFO.sUSRSchemaInfo, which returns the full list of
schemas for alex. Departing from the JDBC convention, however, disturbs
me.

Is this a planned behavior, or a bug?

Alex Molochnikov


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]