You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by sc...@apache.org on 2007/09/16 20:17:38 UTC
svn commit: r576142 - in /db/derby/docs/trunk/src/ref: refderby.ditamap
rrefemptystmtcache.dita rrefgetuseraccess.dita rrefsetuseraccess.dita
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