RE: getSchemas() for a user

Thank you, Toby.

-----Original Message-----
From: Tobias Downer [mailto:[email protected]] 
Sent: Monday, December 13, 2004 11:49 AM
To: [email protected]
Subject: 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.


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