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 <[EMAIL PROTECTED]> 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
