You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2011/07/15 20:56:06 UTC
svn commit: r1147279 - /db/derby/docs/trunk/src/ref/
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');