db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r906505 - in /db/derby/docs/trunk/src/ref: rrefselectexpression.dita rrefsqlj41360.dita rrefsqljgrant.dita
Date Thu, 04 Feb 2010 14:45:41 GMT
Author: chaase3
Date: Thu Feb  4 14:45:41 2010
New Revision: 906505

URL: http://svn.apache.org/viewvc?rev=906505&view=rev
Log:
DERBY-4522: Document SELECT statement requirements resulting from fix to DERBY-4191

Made changes to 3 files in Reference Manual.

Patch: DERBY-4522-2.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefselectexpression.dita
    db/derby/docs/trunk/src/ref/rrefsqlj41360.dita
    db/derby/docs/trunk/src/ref/rrefsqljgrant.dita

Modified: db/derby/docs/trunk/src/ref/rrefselectexpression.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefselectexpression.dita?rev=906505&r1=906504&r2=906505&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefselectexpression.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefselectexpression.dita Thu Feb  4 14:45:41 2010
@@ -49,7 +49,13 @@
 included in the result. Nulls are considered duplicates of one another for
 the purposes of DISTINCT. If no quantifier, or ALL, is specified, no rows
 are removed from the result in applying the SELECT clause (ALL is the default).</p>
<p>A<i> SelectItem</i> projects
-one or more result column values for a table result being constructed in a <i>SelectExpression</i>.</p>
<p>The
+one or more result column values for a table result being constructed in a <i>SelectExpression</i>.</p>

+<p>For queries that do not select a specific column from the tables involved in
+the <i>SelectExpression</i> (for example, queries that use
+<codeph>COUNT(*)</codeph>), the user must have at least one column-level SELECT
+privilege or table-level SELECT privilege. See
+<xref href="rrefsqljgrant.dita#rrefsqljgrant"></xref> for more information.</p>
+<p>The
 result of the <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref>
is
 the cross product of the FROM items. The <xref href="rrefsqlj33602.dita#rrefsqlj33602">WHERE
 clause</xref> can further qualify this result.</p> <p>The WHERE clause
causes

Modified: db/derby/docs/trunk/src/ref/rrefsqlj41360.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj41360.dita?rev=906505&r1=906504&r2=906505&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj41360.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj41360.dita Thu Feb  4 14:45:41 2010
@@ -45,7 +45,12 @@
 the result set's cursor updatable. The SELECT statement supports the FOR FETCH
 ONLY clause. The FOR FETCH ONLY clause is synonymous with the FOR READ ONLY
 clause.</p> <p>You can set the isolation level in a
-SELECT statement using the WITH {RR|RS|CS|UR} syntax.</p></section>
+SELECT statement using the WITH {RR|RS|CS|UR} syntax.</p>
+<p>For queries that do not select a specific column from the tables involved in
+the SELECT statement (for example, queries that use <codeph>COUNT(*)</codeph>),
+the user must have at least one column-level SELECT privilege or table-level
+SELECT privilege. See <xref href="rrefsqljgrant.dita#rrefsqljgrant"></xref>
+for more information.</p></section>
 
 <example><title>Example</title> <codeblock><b><ph>--
lists the names of the expression 
 -- SAL+BONUS+COMM as TOTAL_PAY and

Modified: db/derby/docs/trunk/src/ref/rrefsqljgrant.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljgrant.dita?rev=906505&r1=906504&r2=906505&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljgrant.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljgrant.dita Thu Feb  4 14:45:41 2010
@@ -98,10 +98,18 @@
 a foreign key reference to the specified table. If a column list is specified
 with the REFERENCES privilege, the permission is valid on only the foreign
 key reference to the specified columns.</p><p>Use the SELECT privilege type
-to grant permission to perform SELECT statements on a table or view. If a
+to grant permission to perform
+<xref href="rrefsqlj41360.dita#rrefsqlj41360">SELECT statements</xref> or
+<i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpressions</xref></i>
+on a table or view. If a
 column list is specified with the SELECT privilege, the permission is valid
 on only those columns. If no column list is specified, then the privilege
-is valid on all of the columns in the table.</p><p>Use the TRIGGER privilege
+is valid on all of the columns in the table.</p>
+<p>For queries that do not select a specific column from the tables involved in
+a SELECT statement or <i>SelectExpression</i> (for example, queries that use
+<codeph>COUNT(*)</codeph>), the user must have at least one column-level SELECT
+privilege or table-level SELECT privilege.</p>
+<p>Use the TRIGGER privilege
 type to grant permission to create a trigger on the specified table.</p><p>Use
 the UPDATE privilege type to grant permission to use the UPDATE statement
 on the specified table. If a column list is specified, the permission applies



Mime
View raw message