Re: getSchemas() for a user

The 'secure access' attribute does not give the user full privs on any 
schema.  The user that created a schema must grant the users that they 
wish to see the schema;

   grant all on schema Scribe to alex;

If you run that command then alex should be able to see the schema.

Toby.

Alexandr Molochnikov wrote:

> 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]