db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1340237 - /db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
Date Fri, 18 May 2012 20:33:29 GMT
Author: chaase3
Date: Fri May 18 20:33:29 2012
New Revision: 1340237

URL: http://svn.apache.org/viewvc?rev=1340237&view=rev
DERBY-5566  CREATE SCHEMA should state that one cannot create a new schema starting with "SYS"
in case normal form 

Modified a Reference Manual topic.

Patch: DERBY-5566-2.diff


Modified: db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=1340237&r1=1340236&r2=1340237&view=diff
--- db/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31580.dita Fri May 18 20:33:29 2012
@@ -34,6 +34,8 @@ and provide a unique namespace for objec
 </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> 
+<p>A schema name cannot start with the prefix SYS (after case normalization).
+Use of the prefix SYS raises a <i>SQLException</i>.</p>
 <p>The CREATE SCHEMA statement is subject to access control when the 
 <codeph><xref href="rrefpropersqlauth.dita#rrefpropersqlauth">derby.database.sqlAuthorization</xref></codeph>
property is set to 
 <codeph>true</codeph> for the database or system. Only the database owner can
create a schema with a name 

View raw message