> -----Original Message-----
> From: Zeugswetter Andreas SB
>
> > 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.
Regards.
Hiroshi Inoue