db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen <Oystein.Grov...@Sun.COM>
Subject Re: Database connection not bound to default database schema when authenticating through LDAP?
Date Fri, 06 Jun 2008 06:47:06 GMT
Andreas Kyrmegalos wrote:
> Hello again,
>   I don't know what to make of this. I blame it to the late hour though.
> After successfully authenticating user usertest through LDAP to 
> establish a connection , I get this message
> ERROR 42Y07: Schema 'usertest' does not exist
> when executing a statement against the database. The database's schema 
> is not 'usertest'. And the database
> creator is not 'usertest' either.The same error is reported with other 
> user names.
> I was under the impression that a database connection is bound to the 
> default database schema regardless
> of the user name used to connect. Is this a LDAP related thing? Or  is 
> it just the right time to hit the sack?

The default schema is the same as the username, regardless of whether it 
exists or not.  You can use 'set schema' to switch to another schema.


View raw message