On Wed, Jun 28, 2000 at 02:07:33PM +0200, Zeugswetter Andreas SB wrote:
>
> > 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.
To quote from the SQL92 standard for CERATE SCHEMA:
<schema definition> ::= CREATE SCHEMA <schema name clause> [ <schema character set
specification>] [ <schema element>... ]
<schema name clause> ::= <schema name> | AUTHORIZATION <schema authorization
identifier> | <schema name> AUTHORIZATION <schema authorization identifier>
1) If <schema name> is not specified, then a <schema name> equal to <schema authorization identifier>
isimplicit.
2) If AUTHORIZATION <schema authorization identifier> is not speci- fied, then
Case:
a) If the <schema definition> is contained in a <module> that has a <module authorization
identifier>specified, then an <authorization identifier> equal to that <module authoriza- tion
identifier>is implicit for the <schema definition>.
b) Otherwise, an <authorization identifier> equal to the SQL- session <authorization identifier>
isimplicit.
So, we see that the SQL92 default fora schema is the session username.
> In both, a user can access other schemas or switch to another
> schema, so in that sense you could say that the schema is
> independent of users.
Not only in a sense, it is in fact.
>
> This will definitely be a problem because of our current nested dot
> interpretation towards functions taking one opaque or _class_type
> argument.
Right. If we're going to support SQL92 dot notation (which I think we
should) we'll either need to lose the function notion completely, or
come up with some really clever hack about applying them in order.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005