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
>
|