db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart" <scotsmat...@gmail.com>
Subject Question - CREATE SCHEMA examples
Date Wed, 13 Sep 2006 21:19:33 GMT
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