svn commit: r586051 - in /db/derby/docs/trunk/src/ref: rrefgetuseraccess.dita rrefsetuseraccess.dita

[sc...@apache.org]

Author: scotsmatrix
Date: Thu Oct 18 11:23:43 2007
New Revision: 586051

URL: http://svn.apache.org/viewvc?rev=586051&view=rev
Log:
Derby-2914: Corrected some errors, added an example, removed NULL from Get function.

Modified:
    db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
    db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita

Modified: db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita?rev=586051&r1=586050&r2=586051&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita Thu Oct 18 11:23:43 2007
@@ -19,9 +19,9 @@
 limitations under the License.
 -->
 <reference id="rrefgetuseraccess" xml:lang="en-us">
-<title>SYSCS_UTIL.SYSCS_GET_USER_ACCESS system procedure</title>
+<title>SYSCS_UTIL.SYSCS_GET_USER_ACCESS system function</title>
 <refbody>
-<section><p>The <codeph>SYSCS_UTIL.SYSCS_GET_USER_ACCESS</codeph> stored procedure
+<section><p>The <codeph>SYSCS_UTIL.SYSCS_GET_USER_ACCESS</codeph> function
 returns the current connection access permissions that is for the user specified,
 and factors in the default connection mode.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_GET_USER_ACCESS (USERNAME VARCHAR(128)) RETURNS VARCHAR(128)</codeblock><dl>
@@ -29,13 +29,13 @@
 <dt>USERNAME</dt>
 <dd>An input argument of type VARCHAR(128) that specifies the user ID on the <ph
 conref="../conrefs.dita#prod/productshortname"></ph> database. </dd>
-</dlentry></dl><p>The value that is returned by this procedure is either FULL,
-NO, NULL, or READONLY.  </p><p>A return value of NO means that the connection
-attempt by the user will be denied because neither the <varname>derby.database.fullAccessUsers</varname> property
+</dlentry></dl><p>The value that is returned by this procedure is either FULLACCESS,
+READONLYACCESS, or NOACCESS.</p><p>A return value of NOACCESS means that the
+connection attempt by the user will be denied because neither the <varname>derby.database.fullAccessUsers</varname> property
 or the <varname>derby.database.readOnlyAccessUsers</varname> property is set
 for the user, and the <varname>derby.database.defaultConnectionMode</varname> property
 is set to noAccess.</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>Example</title> <codeblock>CALL SYSCS_UTIL.SYSCS_GET_USER_ACCESS ('BRUNNER')</codeblock></section>
+<section><title>Example</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_GET_USER_ACCESS ('BRUNNER')</codeblock></section>
 </refbody>
 </reference>

Modified: db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita?rev=586051&r1=586050&r2=586051&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita Thu Oct 18 11:23:43 2007
@@ -30,19 +30,21 @@
 </dlentry><dlentry>
 <dt>CONNECTION_PERMISSION</dt>
 <dd> <p>Valid values for CONNECTION_PERMISSION are:</p><dl><dlentry>
-<dt>FULL</dt>
+<dt>FULLACCESS</dt>
 <dd>Adds the user to the list of users with full access to the database. The
-value for the database property is<varname>derby.database.fullAccessUsers</varname>.</dd>
+value for the database property is <varname>derby.database.fullAccessUsers</varname>.</dd>
 </dlentry><dlentry>
-<dt>READONLY</dt>
+<dt>READONLYACCESS</dt>
 <dd>Adds the user to the list of users with read-only access to the database.
 The value for the database property is <varname>derby.database.readOnlyAccessUsers</varname>. </dd>
 </dlentry><dlentry>
 <dt>NULL</dt>
 <dd>Removes the user from the list of permissions, reverting the user to the
-default permission.</dd>
+default permission. You must specify NULL without the quotation marks.</dd>
 </dlentry></dl></dd>
 </dlentry></dl></section>
-<section><title>Example</title><codeblock>CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS ('BRUNNER', 'READONLY')</codeblock></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 NULL value without
+the quotation marks. For example:</p><codeblock>CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS ('ISABEL', NULL)</codeblock></section>
 </refbody>
 </reference>