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/25 19:47:28 UTC
svn commit: r1150806 - /db/derby/docs/trunk/src/ref/
Author: chaase3
Date: Mon Jul 25 17:47:23 2011
New Revision: 1150806
URL: http://svn.apache.org/viewvc?rev=1150806&view=rev
Log:
DERBY-5329 Document who is allowed to run which system procedures/functions
Modifications to 33 Reference Manual topics.
Patch: DERBY-5329-2.diff
Modified:
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/rrefsetuseraccess.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/rrefunfreezedbproc.dita
db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita
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=1150806&r1=1150805&r2=1150806&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 Mon Jul 25 17:47:23 2011
@@ -37,10 +37,12 @@ executed normally.
<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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this function by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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>
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=1150806&r1=1150805&r2=1150806&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 Mon Jul 25 17:47:23 2011
@@ -41,10 +41,12 @@ limitations under the License.
<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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this function by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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>
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=1150806&r1=1150805&r2=1150806&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 Mon Jul 25 17:47:23 2011
@@ -38,10 +38,12 @@ procedure for more information.</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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
</section>
<section><title>Example</title>
<p>To let
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=1150806&r1=1150805&r2=1150806&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 Mon Jul 25 17:47:23 2011
@@ -46,10 +46,12 @@ argument.</p></section>
<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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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>
Modified: db/derby/docs/trunk/src/ref/rrefaltertablecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefaltertablecompress.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefaltertablecompress.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefaltertablecompress.dita Mon Jul 25 17:47:23 2011
@@ -53,11 +53,13 @@ run in sequential mode, while an argumen
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
+<p>If authentication and SQL authorization are both enabled, 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>
+schema in which the table resides. See "Enabling user authentication" and
+"Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information.</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>
Modified: db/derby/docs/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbenablelognowaitproc.dita Mon Jul 25 17:47:23 2011
@@ -49,10 +49,12 @@ backup will be deleted. The log files ar
backup.</dd>
</dlentry></dl></section>
<section><title>Execute privileges</title>
-<p>By default, only the
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefbackupdbenablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbenablelogproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbenablelogproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbenablelogproc.dita Mon Jul 25 17:47:23 2011
@@ -46,10 +46,12 @@ backup will be deleted. The log files ar
backup.</dd>
</dlentry></dl></section>
<section><title>Execute privileges</title>
-<p>By default, only the
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefbackupdbnowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbnowaitproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbnowaitproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbnowaitproc.dita Mon Jul 25 17:47:23 2011
@@ -42,10 +42,12 @@ JVM where the database backup is occurri
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefbackupdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbackupdbproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbackupdbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbackupdbproc.dita Mon Jul 25 17:47:23 2011
@@ -38,10 +38,12 @@ JVM where the database backup is occurri
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefcheckpointdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcheckpointdbproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcheckpointdbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcheckpointdbproc.dita Mon Jul 25 17:47:23 2011
@@ -26,10 +26,12 @@ procedure checkpoints the database by fl
<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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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()");
Modified: db/derby/docs/trunk/src/ref/rrefdisablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdisablelogproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdisablelogproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdisablelogproc.dita Mon Jul 25 17:47:23 2011
@@ -33,10 +33,12 @@ If the parameter value is zero, then exi
not deleted.</dd>
</dlentry></dl></section>
<section><title>Execute privileges</title>
-<p>By default, only the
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita Mon Jul 25 17:47:23 2011
@@ -30,10 +30,12 @@ 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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
</section>
<section><title>JDBC Example</title>
<codeblock>CallableStatement cs = conn.prepareCall
Modified: db/derby/docs/trunk/src/ref/rrefexportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportproc.dita Mon Jul 25 17:47:23 2011
@@ -80,10 +80,13 @@ If you created a schema, table, or colum
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita Mon Jul 25 17:47:23 2011
@@ -100,10 +100,13 @@ characters. If you created a schema or t
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita Mon Jul 25 17:47:23 2011
@@ -71,10 +71,13 @@ set to the specified code set before wri
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita Mon Jul 25 17:47:23 2011
@@ -88,10 +88,13 @@ Specifying a NULL value results in an er
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rreffreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffreezedbproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffreezedbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rreffreezedbproc.dita Mon Jul 25 17:47:23 2011
@@ -26,10 +26,12 @@ temporarily freezes the database for bac
<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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefgetdbpropfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetdbpropfunc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetdbpropfunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefgetdbpropfunc.dita Mon Jul 25 17:47:23 2011
@@ -31,10 +31,12 @@ 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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this function by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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>
Modified: db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita Mon Jul 25 17:47:23 2011
@@ -44,10 +44,12 @@ for the user, and the <codeph>derby.data
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this function by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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>
Modified: db/derby/docs/trunk/src/ref/rrefimportdataproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportdataproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportdataproc.dita Mon Jul 25 17:47:23 2011
@@ -89,10 +89,13 @@ characters. If you created a schema, tab
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita Mon Jul 25 17:47:23 2011
@@ -104,10 +104,13 @@ characters. If you created a schema, tab
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefimportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportproc.dita Mon Jul 25 17:47:23 2011
@@ -77,10 +77,13 @@ characters. If you created a schema, tab
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita Mon Jul 25 17:47:23 2011
@@ -89,10 +89,13 @@ characters. If you created a schema, tab
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita Mon Jul 25 17:47:23 2011
@@ -78,11 +78,13 @@ the PURGE_ROWS and/or DEFRAGMENT_ROWS op
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
+<p>If authentication and SQL authorization are both enabled, 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>
+schema in which the table resides. See "Enabling user authentication" and
+"Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information.</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
Modified: db/derby/docs/trunk/src/ref/rrefreloadpolicyproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefreloadpolicyproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefreloadpolicyproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefreloadpolicyproc.dita Mon Jul 25 17:47:23 2011
@@ -33,10 +33,12 @@ and the section titled "Running Derby un
<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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
</section>
<section><title>Example</title> <codeblock>
CallableStatement cs = conn.prepareCall
Modified: db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita Mon Jul 25 17:47:23 2011
@@ -37,10 +37,12 @@ value.</p></section>
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita Mon Jul 25 17:47:23 2011
@@ -48,10 +48,12 @@ marks.</dd>
</dlentry></dl></dd>
</dlentry></dl></section>
<section><title>Execute privileges</title>
-<p>By default, only the
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefstorejarinstall.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefstorejarinstall.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefstorejarinstall.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefstorejarinstall.dita Mon Jul 25 17:47:23 2011
@@ -54,10 +54,12 @@ argument, so it is normally set to 0.</d
</dl>
</section>
<section><title>Execute privileges</title>
-<p>By default, only the
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
</section>
<section><title>SQL examples</title>
<codeblock><b>-- SQL statement</b>
Modified: db/derby/docs/trunk/src/ref/rrefstorejarremove.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefstorejarremove.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefstorejarremove.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefstorejarremove.dita Mon Jul 25 17:47:23 2011
@@ -48,10 +48,12 @@ argument, so it is normally set to 0.</d
</dl>
</section>
<section><title>Execute privileges</title>
-<p>By default, only the
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
</section>
<section><title>SQL example</title>
<codeblock><b>-- SQL statement</b>
Modified: db/derby/docs/trunk/src/ref/rrefstorejarreplace.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefstorejarreplace.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefstorejarreplace.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefstorejarreplace.dita Mon Jul 25 17:47:23 2011
@@ -48,10 +48,12 @@ MYSCHEMA."Sample2"</codeblock>
</dl>
</section>
<section><title>Execute privileges</title>
-<p>By default, only the
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
</section>
<section><title>SQL example</title>
<codeblock><b>-- SQL statement</b>
Modified: db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita Mon Jul 25 17:47:23 2011
@@ -29,10 +29,12 @@ with value 1. If the table and indexes a
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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this function by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. The
+database owner can grant access to other users.</p>
</section>
<example><title>Examples</title>
<p>Check a single table:</p>
Modified: db/derby/docs/trunk/src/ref/rrefunfreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefunfreezedbproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefunfreezedbproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefunfreezedbproc.dita Mon Jul 25 17:47:23 2011
@@ -26,10 +26,12 @@ procedure unfreezes a database after bac
<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
+<p>If authentication and SQL authorization are both enabled, 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>
+execute privileges on this procedure by default. See "Enabling user
+authentication" and "Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information. 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
Modified: db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita?rev=1150806&r1=1150805&r2=1150806&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefupdatestatsproc.dita Mon Jul 25 17:47:23 2011
@@ -43,9 +43,13 @@ can specify <userinput>null</userinput>
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>
+<p>If authentication and SQL authorization are both enabled, 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. See "Enabling user authentication" and
+"Setting the SQL standard authorization mode" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph> for more information.</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