db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scotsmat...@apache.org
Subject svn commit: r587661 - in /db/derby/docs/trunk/src/ref: refderby.ditamap rrefgetuseraccess.dita rrefsetuseraccess.dita
Date Tue, 23 Oct 2007 21:29:17 GMT
Author: scotsmatrix
Date: Tue Oct 23 14:29:16 2007
New Revision: 587661

URL: http://svn.apache.org/viewvc?rev=587661&view=rev
Log:
Derby2914: Clarified the get user access function, moved the file under the functions section,
updated the syntax, updated the examples.

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

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=587661&r1=587660&r2=587661&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Tue Oct 23 14:29:16 2007
@@ -184,7 +184,8 @@
 <topicref href="rrefselectexpression.dita" navtitle="SelectExpression"></topicref>
 <topicref collection-type="family" href="rreftableexpression.dita" navtitle="TableExpression">
 <topicref href="rrefsqlj33215.dita" navtitle="TableViewOrFunctionExpression">
-<topicref href="rrefsqljtfinvoke.dita" navtitle="TableFunctionInvocation"></topicref>
+<topicref href="rrefsqljtfinvoke.dita" navtitle="TableFunctionInvocation">
+</topicref>
 </topicref>
 </topicref>
 <topicref href="rrefsqlj11277.dita" navtitle="VALUES expression"></topicref>
@@ -295,6 +296,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.-->
@@ -338,15 +341,13 @@
 </topicref>
 <topicref href="rrefreloadpolicyproc.dita" navtitle="SYSCS_UTIL.SYSCS_RELOAD_SECURITY_POLICY
system procedure">
 </topicref>
-<topicref href="rrefgetuseraccess.dita" navtitle="SYSCS_UTIL.SYSCS_GET_USER_ACCESS stored
procedure">
-</topicref>
-<topicref href="rrefsetuseraccess.dita" navtitle="SYSCS_UTIL.SYSCS_SET_USER_ACCESS stored
procedure">
-</topicref>
 <topicref href="rrefsetdbpropproc.dita" navtitle="SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY
system procedure">
 </topicref>
 <topicref href="rrefsqlj38831.dita" navtitle="SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system
procedure">
 </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">

Modified: db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita?rev=587661&r1=587660&r2=587661&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita Tue Oct 23 14:29:16 2007
@@ -22,20 +22,24 @@
 <title>SYSCS_UTIL.SYSCS_GET_USER_ACCESS system function</title>
 <refbody>
 <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>
+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
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
+</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>
+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>

Modified: db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita?rev=587661&r1=587660&r2=587661&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita Tue Oct 23 14:29:16 2007
@@ -21,30 +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>FULLACCESS</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>
 </dlentry><dlentry>
-<dt>READONLYACCESS</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. You must specify NULL without the quotation marks.</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', '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>
+<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