You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Laura Stewart <sc...@gmail.com> on 2006/09/13 23:19:33 UTC
Question - CREATE SCHEMA examples
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
Re: Question - CREATE SCHEMA examples
Posted by Laura Stewart <sc...@gmail.com>.
On 9/13/06, Yip Ng <yi...@gmail.com> wrote:
> 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
Yes, VERY helpful, thanks!
--
Laura Stewart
Re: Question - CREATE SCHEMA examples
Posted by Yip Ng <yi...@gmail.com>.
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 <sc...@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
>