db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1147279 - /db/derby/docs/trunk/src/ref/
Date Fri, 15 Jul 2011 18:56:06 GMT
Author: chaase3
Date: Fri Jul 15 18:56:03 2011
New Revision: 1147279

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

Updated 36 Reference Manual topics and the map file.

Patch: DERBY-5329.diff

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

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Fri Jul 15 18:56:03 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/trunk/src/ref/rref_syscs_get_xplain_mode.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rref_syscs_get_xplain_mode.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rref_syscs_get_xplain_mode.dita (original)
+++ db/derby/docs/trunk/src/ref/rref_syscs_get_xplain_mode.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rref_syscs_get_xplain_schema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rref_syscs_get_xplain_schema.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rref_syscs_get_xplain_schema.dita (original)
+++ db/derby/docs/trunk/src/ref/rref_syscs_get_xplain_schema.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rref_syscs_set_xplain_mode.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rref_syscs_set_xplain_mode.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rref_syscs_set_xplain_mode.dita (original)
+++ db/derby/docs/trunk/src/ref/rref_syscs_set_xplain_mode.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rref_syscs_set_xplain_schema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rref_syscs_set_xplain_schema.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rref_syscs_set_xplain_schema.dita (original)
+++ db/derby/docs/trunk/src/ref/rref_syscs_set_xplain_schema.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefaltertablecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefaltertablecompress.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefaltertablecompress.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefaltertablecompress.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefbackupdbenablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbenablelogproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbenablelogproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbenablelogproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefbackupdbnowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbnowaitproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbnowaitproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbnowaitproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefbackupdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefcheckpointdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcheckpointdbproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcheckpointdbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcheckpointdbproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefdisablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdisablelogproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdisablelogproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdisablelogproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefemptystmtcache.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefexportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefexportproctablelobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefexportselectionproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefexportselectionproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rreffreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffreezedbproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffreezedbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rreffreezedbproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefgetdbpropfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetdbpropfunc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetdbpropfunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefgetdbpropfunc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefimportdataproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportdataproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportdataproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefimportdataproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefimportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefimporttableproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefproceduresinplacecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefreloadpolicyproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefreloadpolicyproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefreloadpolicyproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefreloadpolicyproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefsetdbpropproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefsetstatstimingproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetstatstimingproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetstatstimingproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetstatstimingproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefsqlj38831.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj38831.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj38831.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj38831.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefstorejarinstall.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefstorejarinstall.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefstorejarinstall.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefstorejarinstall.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefstorejarremove.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefstorejarremove.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefstorejarremove.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefstorejarremove.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefstorejarreplace.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefstorejarreplace.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefstorejarreplace.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefstorejarreplace.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefsyscsruntimestatsfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscsruntimestatsfunc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscsruntimestatsfunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscsruntimestatsfunc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefunfreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefunfreezedbproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefunfreezedbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefunfreezedbproc.dita Fri Jul 15 18:56:03 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/trunk/src/ref/rrefupdatestatsproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita?rev=1147279&r1=1147278&r2=1147279&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita Fri Jul 15 18:56:03 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