db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1147295 - /db/derby/docs/branches/10.8/src/ref/
Date Fri, 15 Jul 2011 19:42:39 GMT
Author: chaase3
Date: Fri Jul 15 19:42:38 2011
New Revision: 1147295

URL: http://svn.apache.org/viewvc?rev=1147295&view=rev
Log:
DERBY-5329  Document who is allowed to run which system procedures/functions.

Merged DERBY-5329.diff to 10.8 docs branch from trunk revision 1147279.

Modified:
    db/derby/docs/branches/10.8/src/ref/refderby.ditamap
    db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita
    db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita
    db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita
    db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita
    db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita
    db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita
    db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita
    db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita
    db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita
    db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita
    db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita
    db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefsetstatstimingproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita
    db/derby/docs/branches/10.8/src/ref/rrefsqlj38831.dita
    db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita
    db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita
    db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita
    db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita
    db/derby/docs/branches/10.8/src/ref/rrefsyscsruntimestatsfunc.dita
    db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita

Modified: db/derby/docs/branches/10.8/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/refderby.ditamap?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/refderby.ditamap (original)
+++ db/derby/docs/branches/10.8/src/ref/refderby.ditamap Fri Jul 15 19:42:38 2011
@@ -416,10 +416,10 @@ limitations under the License.
 </topicref>
 <topicref href="rrefsetstatstimingproc.dita" navtitle="SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure">
 </topicref>
-<topicref href="rref_syscs_set_xplain_schema.dita" navtitle="SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure"> </topicref>
-<topicref href="rref_syscs_set_xplain_mode.dita" navtitle="SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE system procedure"> </topicref>
 <topicref href="rrefsetuseraccess.dita" navtitle="SYSCS_UTIL.SYSCS_SET_USER_ACCESS stored procedure">
 </topicref>
+<topicref href="rref_syscs_set_xplain_mode.dita" navtitle="SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE system procedure"> </topicref>
+<topicref href="rref_syscs_set_xplain_schema.dita" navtitle="SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure"> </topicref>
 <topicref href="rrefupdatestatsproc.dita" navtitle="SYSCS_UTIL.SYSCS_UPDATE_STATISTICS stored procedure">
 </topicref>
 <topicref collection-type="family" href="crefstorejardb.dita" navtitle="System procedures for storing jar files in a database">

Modified: db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita Fri Jul 15 19:42:38 2011
@@ -36,6 +36,12 @@ executed normally.
 </section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_GET_XPLAIN_MODE() RETURNS INTEGER</codeblock>
 </section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this function. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title>
     <p>To determine the current value of the XPLAIN mode:</p>
     <codeblock>

Modified: db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita Fri Jul 15 19:42:38 2011
@@ -40,6 +40,12 @@ limitations under the License.
 </section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA () RETURNS VARCHAR</codeblock>
 </section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this function. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title>
     <p>To determine the current value of the XPLAIN schema:</p>
     <codeblock>

Modified: db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita Fri Jul 15 19:42:38 2011
@@ -37,6 +37,12 @@ procedure for more information.</p>
             </p>
 </section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE(IN SMALLINT NOEXECUTE)</codeblock></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title>
     <p>To let 
         <ph conref="../conrefs.dita#prod/productshortname"></ph>

Modified: db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita Fri Jul 15 19:42:38 2011
@@ -45,6 +45,12 @@ argument.</p></section>
         an empty argument or by calling
         <codeph>SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0)</codeph></p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA(IN VARCHAR(128) SCHEMA_NAME)</codeblock></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title>
     <p>To cause <ph conref="../conrefs.dita#prod/productshortname"></ph>
         to record statistics about statement execution in

Modified: db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita Fri Jul 15 19:42:38 2011
@@ -52,6 +52,13 @@ argument of "Fred" will be passed to SQL
 run in sequential mode, while an argument of 0 will force the operation not
 to run in sequential mode. Passing a null will result in an error.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, all users have execute privileges on this procedure. However, in
+order for the procedure to run successfully on a given table, the user must be
+the owner of either the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database</xref> or the
+schema in which the table resides.</p>
+</section>
 <section><title>SQL example</title> <p>To compress a table called CUSTOMER
 in a schema called US, using the SEQUENTIAL option:</p> <codeblock><b>call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('US', 'CUSTOMER', 1)</b></codeblock></section>
 <section><title>Java example</title> <p>To compress a table called CUSTOMER

Modified: db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita Fri Jul 15 19:42:38 2011
@@ -48,6 +48,12 @@ is a non-zero value, online archived log
 backup will be deleted. The log files are deleted only after a successful
 backup.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC example</title><p>The following example backs up the
 database to the <codeph>c:/backupdir</codeph> directory and enables log archive
 mode:</p><codeblock>CallableStatement cs = conn.prepareCall

Modified: db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita Fri Jul 15 19:42:38 2011
@@ -45,6 +45,12 @@ is a non-zero value, online archived log
 backup will be deleted. The log files are deleted only after a successful
 backup.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC example</title><p>The following example backs up the
 database to the <codeph>c:/backupdir</codeph> directory:</p><codeblock>CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE(?, ?)");

Modified: db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita Fri Jul 15 19:42:38 2011
@@ -41,6 +41,12 @@ based on the current user directory, <fi
 JVM where the database backup is occurring. Relative paths are not resolved
 based on the derby home directory. To avoid confusion, use the absolute path.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC example</title><p>The following example backs up the
 database to the <codeph>c:/backupdir</codeph> directory:</p><codeblock>CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT(?)");

Modified: db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita Fri Jul 15 19:42:38 2011
@@ -37,6 +37,12 @@ based on the current user directory, <fi
 JVM where the database backup is occurring. Relative paths are not resolved
 based on the derby home directory. To avoid confusion, use the absolute path.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC example</title> <p>The following example backs up the
 database to the <codeph>c:/backupdir</codeph> directory:</p> <codeblock>CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)");

Modified: db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita Fri Jul 15 19:42:38 2011
@@ -25,6 +25,12 @@ limitations under the License.
 procedure checkpoints the database by flushing all cached data to disk.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()</codeblock> <p>No
 result is returned by this procedure.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC example</title> <codeblock>CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()");
 cs.execute();

Modified: db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita Fri Jul 15 19:42:38 2011
@@ -32,6 +32,12 @@ is a non-zero value, then all existing o
 If the parameter value is zero, then exiting online archived log files are
 not deleted.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC example</title><p>The following example disables log
 archive mode for the database and deletes any existing log archive files.</p><codeblock>CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(?)");

Modified: db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita Fri Jul 15 19:42:38 2011
@@ -29,6 +29,12 @@ collected, so the cache is not guarantee
 to this procedure.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()</codeblock>
 </section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC Example</title>
 <codeblock>CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()");

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita Fri Jul 15 19:42:38 2011
@@ -79,6 +79,12 @@ you must pass the name to the export pro
 If you created a schema, table, or column name as a delimited identifier,
 you must pass the name to the export procedure using the same case that was
 used when it was created.</section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have SELECT privileges on the table.</p>
+</section>
 <section><title>Usage</title>
 <p>For additional information on using this procedure, see the section
 "Importing and exporting data" in the

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita Fri Jul 15 19:42:38 2011
@@ -99,6 +99,12 @@ identifier, you must pass the name to th
 characters. If you created a schema or table name as a delimited identifier,
 you must pass the name to the export procedure using the same case that was
 used when it was created.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have SELECT privileges on the table.</p>
+</section>
 <section><title>Usage</title>
 <p>For additional information on using this procedure, see the section
 "Importing and exporting data" in the

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita Fri Jul 15 19:42:38 2011
@@ -70,6 +70,12 @@ Java-supported character encodings. Data
 set to the specified code set before writing to the file. Passing a NULL value
 will write the data in the same code set as the JVM in which it is being executed.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have SELECT privileges on the table.</p>
+</section>
 <section><title>Usage</title>
 <p>For additional information on using this procedure, see the section
 "Importing and exporting data" in the

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita Fri Jul 15 19:42:38 2011
@@ -87,6 +87,12 @@ If you are using the Network Server, the
 Specifying a NULL value results in an error. The <parmname>LOBSFILENAME</parmname> parameter
 takes an input argument that is a VARCHAR (32672) data type.</dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have SELECT privileges on the table.</p>
+</section>
 <section><title>Usage</title>
 <p>For additional information on using this procedure, see the section
 "Importing and exporting data" in the

Modified: db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita Fri Jul 15 19:42:38 2011
@@ -25,6 +25,12 @@ limitations under the License.
 temporarily freezes the database for backup.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_FREEZE_DATABASE()</codeblock> <p>No
 result set is returned by this procedure.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title> <codeblock>String backupdirectory = "c:/mybackups/" + JCalendar.getToday();
 CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()");

Modified: db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita Fri Jul 15 19:42:38 2011
@@ -30,6 +30,12 @@ invalid value, but <ph conref="../conref
 the default value.</p></section>
 <section><title>Syntax</title> <codeblock>VARCHAR(32672) SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN KEY VARCHAR(128))</codeblock> <p>An
 error will be returned if KEY is null.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this function. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>SQL example</title> <p>Retrieve the value of the
 <codeph>derby.locks.deadlockTimeout</codeph> property:</p>
 <codeblock>VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.locks.deadlockTimeout');</codeblock></section>

Modified: db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita Fri Jul 15 19:42:38 2011
@@ -43,6 +43,12 @@ property is set
 for the user, and the <codeph>derby.database.defaultConnectionMode</codeph> property
 is set to <codeph>noAccess</codeph>.</p><p>The names of the connection permissions
 match the existing names in use by <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this function. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_GET_USER_ACCESS ('BRUNNER')</codeblock></section>
 </refbody>
 </reference>

Modified: db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita Fri Jul 15 19:42:38 2011
@@ -88,6 +88,12 @@ identifier, you must pass the name to th
 characters. If you created a schema, table, or column name as a delimited
 identifier, you must pass the name to the import procedure using the same
 case that was used when it was created.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have INSERT privileges on the table.</p>
+</section>
 <section><title>Usage</title>
 <p>For additional information on using this procedure, see the section
 "Importing and exporting data" in the

Modified: db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita Fri Jul 15 19:42:38 2011
@@ -103,6 +103,12 @@ identifier, you must pass the name to th
 characters. If you created a schema, table, or column name as a delimited
 identifier, you must pass the name to the import procedure using the same
 case that was used when it was created.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have INSERT privileges on the table.</p>
+</section>
 <section><title>Usage</title><p>This procedure will read the LOB data using
 the reference that is stored in the main import file. The format of the reference
 to the LOB stored in the main import file must be <codeph>lobsFileName.Offset.length/</codeph>. </p><ul>

Modified: db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita Fri Jul 15 19:42:38 2011
@@ -76,6 +76,12 @@ identifier, you must pass the name to th
 characters. If you created a schema, table, or column name as a delimited
 identifier, you must pass the name to the import procedure using the same
 case that was used when it was created.</section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have INSERT privileges on the table.</p>
+</section>
 <section><title>Usage</title>
 <p>For additional information on using this procedure, see the section
 "Importing and exporting data" in the

Modified: db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita Fri Jul 15 19:42:38 2011
@@ -88,6 +88,12 @@ identifier, you must pass the name to th
 characters. If you created a schema, table, or column name as a delimited
 identifier, you must pass the name to the import procedure using the same
 case that was used when it was created.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users. The user must also have INSERT privileges on the table.</p>
+</section>
 <section><title>Usage</title><p>This procedure will read the LOB data using
 the reference that is stored in the main import file. If you are importing
 from a non-Derby source, the format of the reference to the LOB stored in

Modified: db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita Fri Jul 15 19:42:38 2011
@@ -77,6 +77,13 @@ at the end of the table will be returned
 the PURGE_ROWS and/or DEFRAGMENT_ROWS options may increase the number of pages
 affected. This option by itself performs no scans of the table. </dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, all users have execute privileges on this procedure. However, in
+order for the procedure to run successfully on a given table, the user must be
+the owner of either the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database</xref> or the
+schema in which the table resides.</p>
+</section>
 <section><title>SQL example</title><p>To compress a table called CUSTOMER
 in a schema called US, using all available compress options:<codeblock><b>call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 1, 1, 1);</b
 ></codeblock></p><p>To return the empty free space at the end of the same

Modified: db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita Fri Jul 15 19:42:38 2011
@@ -32,6 +32,12 @@ and the section titled "Running Derby un
 </p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_RELOAD_SECURITY_POLICY()</codeblock> <p>No
 result set is returned by this procedure.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title> <codeblock>
 CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_RELOAD_SECURITY_POLICY()");

Modified: db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita Fri Jul 15 19:42:38 2011
@@ -36,6 +36,12 @@ value.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(IN KEY VARCHAR(128),
 IN VALUE VARCHAR(32672))</codeblock> <p>This procedure does not return any
 results.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>JDBC example</title> <p>Set the
 <codeph><xref href="rrefproper10607.dita#rrefproper10607">derby.locks.deadlockTimeout</xref></codeph> property
 to a value of 10:</p> <codeblock>CallableStatement cs = conn.prepareCall

Modified: db/derby/docs/branches/10.8/src/ref/rrefsetstatstimingproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsetstatstimingproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsetstatstimingproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsetstatstimingproc.dita Fri Jul 15 19:42:38 2011
@@ -36,6 +36,9 @@ is included in the information returned 
 function. When statistics timing is turned off, the <xref href="rrefsyscsruntimestatsfunc.dita#rrefsyscsruntimestatsfunc">SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS</xref> system
 function shows all timing values as zero.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(IN SMALLINT ENABLE)</codeblock></section>
+<section><title>Execute privileges</title>
+<p>By default, all users have execute privileges on this procedure.</p>
+</section>
 <section><title>Example</title> <p>To turn the <codeph>runtimestatistics</codeph> attribute
 and then the statistics timing attribute on:</p> <codeblock>CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
 CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);</codeblock></section>

Modified: db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita Fri Jul 15 19:42:38 2011
@@ -47,6 +47,12 @@ default permission. You must specify <co
 marks.</dd>
 </dlentry></dl></dd>
 </dlentry></dl></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title><codeblock>CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS ('BRUNNER', 'READONLYACCESS')</codeblock><p>To
 remove the user from the list of permissions, you specify the <codeph>null</codeph> value
 without the quotation marks. For example:</p><codeblock>CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS ('ISABEL', null)</codeblock></section>

Modified: db/derby/docs/branches/10.8/src/ref/rrefsqlj38831.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsqlj38831.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsqlj38831.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsqlj38831.dita Fri Jul 15 19:42:38 2011
@@ -36,6 +36,9 @@ program. For statements that return rows
 returns 0 rows or if a <codeph>close()</codeph> call is encountered, whichever
 comes first.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(IN SMALLINT ENABLE)</codeblock></section>
+<section><title>Execute privileges</title>
+<p>By default, all users have execute privileges on this procedure.</p>
+</section>
 <section><title>Example</title> <codeblock>-- establish a connection
 -- turn on RUNTIMESTATISTIC for connection:
 <b>CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);</b>

Modified: db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita Fri Jul 15 19:42:38 2011
@@ -53,6 +53,12 @@ argument, so it is normally set to 0.</d
 </dlentry>
 </dl>
 </section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>SQL examples</title>
 <codeblock><b>-- SQL statement</b>
 CALL SQLJ.INSTALL_JAR('tours.jar', 'APP.Sample1', 0)

Modified: db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita Fri Jul 15 19:42:38 2011
@@ -47,6 +47,12 @@ argument, so it is normally set to 0.</d
 </dlentry>
 </dl>
 </section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>SQL example</title>
 <codeblock><b>-- SQL statement</b>
 CALL SQLJ.REMOVE_JAR('APP.Sample1', 0)</codeblock>

Modified: db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita Fri Jul 15 19:42:38 2011
@@ -29,8 +29,8 @@ The SQLJ.REPLACE_JAR system procedure re
 </keywords></metadata></prolog>
 <refbody>
 <section><title>Syntax</title>
-<codeblock>SQLJ.REPLACE_JAR(IN JAR_FILE_PATH VARCHAR(32762), 
-                 IN QUALIFIED_JAR_NAME VARCHAR(32762))</codeblock>
+<codeblock>SQLJ.REPLACE_JAR(IN JAR_FILE_PATH VARCHAR(32672), 
+                 IN QUALIFIED_JAR_NAME VARCHAR(32672))</codeblock>
 <dl>
 <dlentry><dt>JAR_FILE_PATH</dt>
 <dd>The path and physical name of the jar file to use as a replacement. For
@@ -47,6 +47,12 @@ MYSCHEMA."Sample2"</codeblock>
 </dlentry>
 </dl>
 </section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>SQL example</title>
 <codeblock><b>-- SQL statement</b>
 CALL sqlj.replace_jar('c:\myjarfiles\newtours.jar', 'APP.Sample1')</codeblock>

Modified: db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita Fri Jul 15 19:42:38 2011
@@ -28,6 +28,12 @@ with value 1. If the table and indexes a
 <refsyn><title>Syntax</title> <codeblock>SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN SCHEMANAME VARCHAR(128),
 IN TABLENAME VARCHAR(128)) </codeblock> <p>An error will occur if either SCHEMANAME
 or TABLENAME are null.</p></refsyn>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this function. The database owner can grant access to
+other users.</p>
+</section>
 <example><title>Examples</title> 
 <p>Check a single table:</p>
 <codeblock>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('SALES', 'ORDERS');</codeblock>

Modified: db/derby/docs/branches/10.8/src/ref/rrefsyscsruntimestatsfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsyscsruntimestatsfunc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsyscsruntimestatsfunc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsyscsruntimestatsfunc.dita Fri Jul 15 19:42:38 2011
@@ -31,6 +31,9 @@ to the node by its children, and the num
 its parent. (The exact statistics are specific to each node type.)   <codeph>SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS</codeph> is
 most meaningful for DML statements such as SELECT, INSERT, DELETE and UPDATE.</p></section>
 <section><title>Syntax</title> <codeblock>VARCHAR(32672) SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS() </codeblock></section>
+<section><title>Execute privileges</title>
+<p>By default, all users have execute privileges on this function.</p>
+</section>
 <section><title>Example</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()</codeblock></section>
 </refbody>
 </reference>

Modified: db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita Fri Jul 15 19:42:38 2011
@@ -25,6 +25,12 @@ limitations under the License.
 procedure unfreezes a database after backup.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()</codeblock> <p>No
 result set is returned by this procedure.</p></section>
+<section><title>Execute privileges</title>
+<p>By default, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure. The database owner can grant access to
+other users.</p>
+</section>
 <section><title>Example</title> <codeblock>String backupdirectory = "c:/mybackups/" + JCalendar.getToday();
 CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()");

Modified: db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita?rev=1147295&r1=1147294&r2=1147295&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita Fri Jul 15 19:42:38 2011
@@ -42,6 +42,11 @@ conref="../conrefs.dita#pub/cittuning"><
 can specify <userinput>null</userinput> for the INDEXNAME to update
 any existing statistics and create statistics for those statistics
 that are missing.</note></section>
+<section><title>Execute privileges</title>
+<p>By default, all users have execute privileges on this procedure. However, in
+order for the procedure to run successfully on a given table, the user must be
+the owner of the table.</p>
+</section>
 <section><title>Examples</title><p>In the following example, the system
 procedure updates statistics for the index PAY_DESC on the SAMP.EMPLOYEE
 table:</p><codeblock>CALL SYSCS_UTIL.SYSCS_UPDATE_STATISTICS('SAMP','EMPLOYEE','PAY_DESC');



Mime
View raw message