db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r584105 - /db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
Date Fri, 12 Oct 2007 09:10:08 GMT
Author: dag
Date: Fri Oct 12 02:10:07 2007
New Revision: 584105

URL: http://svn.apache.org/viewvc?rev=584105&view=rev
DERBY-3084 CREATE SCHEMA in refman does not contain material on restrictions in sqlAuthorization

Patch provided by Kim with input from Dag.


Modified: db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=584105&r1=584104&r2=584105&view=diff
--- db/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31580.dita Fri Oct 12 02:10:07 2007
@@ -33,7 +33,17 @@
 [ AUTHORIZATION <i>user-name</i> ] }</b>
 </codeblock> <p>The CREATE SCHEMA statement is used to create a schema. A
 schema name cannot exceed 128 characters. Schema names must be unique within
-the database.</p> </refsyn>
+the database.</p> 
+<p>The CREATE SCHEMA statement is subject to access control when the 
+<codeph>derby.database.sqlAuthorization</codeph> property is set to 
+<codeph>true</codeph> for the database or system. Only the database owner can
create a schema with a name 
+different from the current user name, and only the the database owner can 
+<codeblock>AUTHORIZATION <i>user-name</i></codeblock>
+with a user name other than the current user name. See 
+<ph conref="../conrefs.dita#pub/cittuning"></ph> for information about the 
+<codeph>derby.database.sqlAuthorization</codeph> property.</p>
 <example><title>CREATE SCHEMA examples</title><p>To create a schema
for airline-related
 tables and give the authorization ID <codeph>anita</codeph> access to all
 of the objects that use the schema, use the following syntax:<codeblock><b>CREATE
SCHEMA FLIGHTS AUTHORIZATION anita</b> </codeblock></p><p>To

View raw message