> > > AFAIK,schema is independent from user in SQL92.
> > > So default_tablespace_per_user doesn't necessarily imply
> > > default_tablespace_per_schema.
> >
> > Well, sombody must be interpreting this wrong, because
> > in Informix and Oracle the schema corresponds to the owner
> > and they say they conform to ansi in this regard.
>
> Is there really a schema:user=1:1 limitation in SQL-92 ?
> Though both SQL-86 and SQL-89 had the limitation
> SQL-92 removed it AFAIK.
As I said in another posting a user does not need to exist
for each schema. The dba can create objects under any
schema name.
Andreas