db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scotsmat...@apache.org
Subject svn commit: r587668 - in /db/derby/docs/branches/10.3/src/ref: refderby.ditamap rrefemptystmtcache.dita rrefgetuseraccess.dita rrefsetuseraccess.dita
Date Tue, 23 Oct 2007 21:50:53 GMT
Author: scotsmatrix
Date: Tue Oct 23 14:50:52 2007
New Revision: 587668

URL: http://svn.apache.org/viewvc?rev=587668&view=rev
Log:
Derby2914: Added new files and updated the ditamap for the new functions and procedures -
get and set user access.

Added:
    db/derby/docs/branches/10.3/src/ref/rrefemptystmtcache.dita
      - copied unchanged from r576142, db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita
    db/derby/docs/branches/10.3/src/ref/rrefgetuseraccess.dita
      - copied, changed from r576142, db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
    db/derby/docs/branches/10.3/src/ref/rrefsetuseraccess.dita
      - copied, changed from r576142, db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
Modified:
    db/derby/docs/branches/10.3/src/ref/refderby.ditamap

Modified: db/derby/docs/branches/10.3/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/ref/refderby.ditamap?rev=587668&r1=587667&r2=587668&view=diff
==============================================================================
--- db/derby/docs/branches/10.3/src/ref/refderby.ditamap (original)
+++ db/derby/docs/branches/10.3/src/ref/refderby.ditamap Tue Oct 23 14:50:52 2007
@@ -185,6 +185,7 @@
 <topicref collection-type="family" href="rreftableexpression.dita" navtitle="TableExpression">
 <topicref href="rrefsqlj33215.dita" navtitle="TableOrViewExpression"></topicref>
 </topicref>
+</topicref>
 <topicref href="rrefsqlj11277.dita" navtitle="VALUES expression"></topicref>
 <topicref href="rrefsqlj1080779.dita" navtitle="Expression precedence"></topicref>
 <topicref href="rrefsqlj23075.dita" navtitle="Boolean expression"></topicref>
@@ -293,6 +294,8 @@
 </topicref>
 <topicref href="rrefsyscsruntimestatsfunc.dita" navtitle="SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS
system function">
 </topicref>
+<topicref href="rrefgetuseraccess.dita" navtitle="SYSCS_UTIL.SYSCS_GET_USER_ACCESS stored
procedure">
+</topicref>
 </topicref>
 <topicref href="crefsqlbuiltinsystemprocedures.dita" navtitle="Built-in system procedures">
 <!--(Laura - March 2007) The topics in this section are intentionally not listed alphabetical
order. They are listed by group of information. For example, the COMPRESS and INPLACE_COMPRESS
topics are listed together; the IMPORT and EXPORT topics are listed together.-->
@@ -304,6 +307,8 @@
 </topicref>
 <topicref href="rrefbackupdbenablelognowaitproc.dita" navtitle="SYSC_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT
system procedure">
 </topicref>
+<topicref href="rrefemptystmtcache.dita" navtitle="SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE
stored procedure">
+</topicref>
 <topicref href="rrefcheckpointdbproc.dita" navtitle="SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE
system procedure">
 </topicref>
 <topicref href="rrefaltertablecompress.dita" navtitle="SYSCS_UTIL.SYSCS_COMPRESS_TABLE
system procedure">
@@ -340,6 +345,8 @@
 </topicref>
 <topicref href="rrefsetstatstimingproc.dita" navtitle="SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING
system procedure">
 </topicref>
+<topicref href="rrefsetuseraccess.dita" navtitle="SYSCS_UTIL.SYSCS_SET_USER_ACCESS stored
procedure">
+</topicref>
 </topicref>
 <topicref href="rrefsyscsdiagtables.dita" navtitle="SYSCS_DIAG diagnostic tables and functions">
 </topicref>
@@ -603,8 +610,7 @@
 </topicref>
 <topicref href="rrefattrib10035.dita" navtitle="user=userName attribute">
 </topicref>
-<topicref href="rrefattribssl.dita" navtitle="ssl=sslMode attribute">
-</topicref>
+<topicref href="rrefattribssl.dita" navtitle="ssl=sslMode attribute"></topicref>
 <topicref href="rrefattrib34183.dita" navtitle="Creating a connection without specifying
attributes">
 </topicref>
 </topicref>

Copied: db/derby/docs/branches/10.3/src/ref/rrefgetuseraccess.dita (from r576142, db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita)
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/ref/rrefgetuseraccess.dita?p2=db/derby/docs/branches/10.3/src/ref/rrefgetuseraccess.dita&p1=db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita&r1=576142&r2=587668&rev=587668&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/branches/10.3/src/ref/rrefgetuseraccess.dita Tue Oct 23 14:50:52 2007
@@ -19,23 +19,27 @@
 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
-returns the current connection access permissions that is for the user specified,
-and factors in the default connection mode.</p></section>
+<section><p>The <codeph>SYSCS_UTIL.SYSCS_GET_USER_ACCESS</codeph>
function
+returns the current connection access permission for the user specified.</p><p>If
+no permission is explicitly set for the user, the access permission for the
+user is the value of the default connection mode. The default connection mode
+is set by using the <codeph>derby.database.defaultConnectionMode</codeph> property.
+See "Derby properties" in <cite><ph conref="../conrefs.dita#pub/cittuning"></ph></cite>
for
+more information about this property.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_GET_USER_ACCESS
(USERNAME VARCHAR(128)) RETURNS VARCHAR(128)</codeblock><dl>
 <dlentry>
 <dt>USERNAME</dt>
-<dd>An input argument of type VARCHAR(128) that specifies the user ID on the <ph
+<dd>An input argument of type VARCHAR(128) that specifies the user ID in 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 function is either
<codeph>fullAccess</codeph>, <codeph>readOnlyAccess</codeph>,
+or <codeph>noAccess</codeph>.</p><p>A return value of <codeph>noAccess</codeph>
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>
+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>Example</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_GET_USER_ACCESS
('BRUNNER')</codeblock></section>
 </refbody>
 </reference>

Copied: db/derby/docs/branches/10.3/src/ref/rrefsetuseraccess.dita (from r576142, db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita)
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/ref/rrefsetuseraccess.dita?p2=db/derby/docs/branches/10.3/src/ref/rrefsetuseraccess.dita&p1=db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita&r1=576142&r2=587668&rev=587668&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/branches/10.3/src/ref/rrefsetuseraccess.dita Tue Oct 23 14:50:52 2007
@@ -21,28 +21,32 @@
 <reference id="rrefsetuseraccess" xml:lang="en-us">
 <title>SYSCS_UTIL.SYSCS_SET_USER_ACCESS system procedure</title>
 <refbody>
-<section><p>The <codeph>SYSCS_UTIL.SYSCS_SET_USER_ACCESS</codeph>
stored procedure
+<section><p>The <codeph>SYSCS_UTIL.SYSCS_SET_USER_ACCESS</codeph>
system procedure
 sets the connection access permission for the user specified.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_SET_USER_ACCESS
(USERNAME VARCHAR(128), CONNECTION_PERMISSION VARCHAR(128))</codeblock
 ><dl><dlentry>
 <dt>USERNAME</dt>
-<dd></dd>
+<dd>An input argument of type VARCHAR(128) that specifies the user ID in the <ph
+conref="../conrefs.dita#prod/productshortname"></ph> database. <p></p></dd>
 </dlentry><dlentry>
 <dt>CONNECTION_PERMISSION</dt>
-<dd> <p>Valid values for CONNECTION_PERMISSION are:</p><dl><dlentry>
-<dt>FULL</dt>
+<dd> Valid values for CONNECTION_PERMISSION are:<dl><dlentry>
+<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>
+<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 <codeph>null</codeph> 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 <codeph>null</codeph>
value
+without the quotation marks. For example:</p><codeblock>CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS
('ISABEL', null)</codeblock></section>
 </refbody>
 </reference>



Mime
View raw message