db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng" <yipng...@gmail.com>
Subject Re: Question - CREATE SCHEMA examples
Date Wed, 13 Sep 2006 21:35:27 GMT
Hi Laura:

CREATE SCHEMA AUTHORIZATION user-name

The second form above creates a new schema that is owned by the named user
and that has the same name as its owner.  i.e.:

CREATE SCHEMA AUTHORIZATION anita

creates a schema named anita that is owned by the user anita.
Hope this helps.

Yip


On 9/13/06, Laura Stewart <scotsmatrix@gmail.com> wrote:
>
> One of the Doc Review comments on the Ref Manual indicates that you can
> specify:
>
> CREATE SCHEMA schema-name AUTHORIZATION user-name
> CREATE SCHEMA AUTHORIZATION user-name
>
> In the first syntax, is this example accurate?
> To create a schema for airline-related tables and give the user ID
> "anita" authorization to all of the objects that use the schema, use
> the following syntax:
> CREATE SCHEMA FLIGHTS AUTHORIZATION anita
>
> Please describe what the second syntax does.  It doesn't specify a
> schema-name, which seems odd. Does this mean that the user ID as
> access to ALL schemas?
>
> --
> Laura Stewart
>

Mime
View raw message