db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1150831 - /db/derby/docs/branches/10.8/src/ref/
Date Mon, 25 Jul 2011 18:31:51 GMT
Author: chaase3
Date: Mon Jul 25 18:31:49 2011
New Revision: 1150831

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

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

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

Modified: db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_mode.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_get_xplain_schema.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_mode.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rref_syscs_set_xplain_schema.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefaltertablecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefaltertablecompress.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelognowaitproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbenablelogproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbnowaitproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefbackupdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefbackupdbproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefcheckpointdbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefcheckpointdbproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefdisablelogproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefdisablelogproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefemptystmtcache.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefemptystmtcache.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefexportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefexportproctablelobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefexportselectionproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefexportselectionproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rreffreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rreffreezedbproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefgetdbpropfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefgetdbpropfunc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefgetuseraccess.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefimportdataproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefimportdataproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefimportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefimporttableproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefproceduresinplacecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefproceduresinplacecompress.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefreloadpolicyproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefreloadpolicyproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefsetdbpropproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsetdbpropproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsetuseraccess.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefstorejarinstall.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarinstall.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefstorejarremove.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarremove.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefstorejarreplace.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefstorejarreplace.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsyscschecktablefunc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefunfreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefunfreezedbproc.dita Mon Jul 25 18:31:49 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/branches/10.8/src/ref/rrefupdatestatsproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita?rev=1150831&r1=1150830&r2=1150831&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefupdatestatsproc.dita Mon Jul 25 18:31:49 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



Mime
View raw message