db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scotsmat...@apache.org
Subject svn commit: r576142 - in /db/derby/docs/trunk/src/ref: refderby.ditamap rrefemptystmtcache.dita rrefgetuseraccess.dita rrefsetuseraccess.dita
Date Sun, 16 Sep 2007 18:17:38 GMT
Author: scotsmatrix
Date: Sun Sep 16 11:17:37 2007
New Revision: 576142

URL: http://svn.apache.org/viewvc?rev=576142&view=rev
Log:
DERBY-2914: Added 3 new files for new system procedures and updated the ditamap file. Patch
was contributed by me.

Added:
    db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita   (with props)
Modified:
    db/derby/docs/trunk/src/ref/refderby.ditamap

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=576142&r1=576141&r2=576142&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Sun Sep 16 11:17:37 2007
@@ -304,6 +304,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">
@@ -334,6 +336,10 @@
 </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">
@@ -603,8 +609,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>

Added: db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita?rev=576142&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita Sun Sep 16 11:17:37 2007
@@ -0,0 +1,29 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rrefemptystmtcache" xml:lang="en-us">
+<title>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure</title>
+<refbody>
+<section><p>The <codeph>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE</codeph>
stored
+procedure is a useful diagnostic tool.</p></section>
+<section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()</codeblock></section>
+<section><title>Example</title><codeblock>CALL SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()</codeblock></section>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rrefemptystmtcache.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita?rev=576142&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita Sun Sep 16 11:17:37 2007
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rrefgetuseraccess" xml:lang="en-us">
+<title>SYSCS_UTIL.SYSCS_GET_USER_ACCESS system procedure</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><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
+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
+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>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita?rev=576142&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita Sun Sep 16 11:17:37 2007
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<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
+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>
+</dlentry><dlentry>
+<dt>CONNECTION_PERMISSION</dt>
+<dd> <p>Valid values for CONNECTION_PERMISSION are:</p><dl><dlentry>
+<dt>FULL</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>READONLY</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>
+</dlentry></dl></dd>
+</dlentry></dl></section>
+<section><title>Example</title><codeblock>CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS
('BRUNNER', 'READONLY')</codeblock></section>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message