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.
--
Øystein
