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 jt...@apache.org on 2006/08/12 02:18:57 UTC

svn commit: r430928 - /db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita

Author: jta
Date: Fri Aug 11 17:18:56 2006
New Revision: 430928

URL: http://svn.apache.org/viewvc?rev=430928&view=rev
Log:
DERBY-1057 (partial): Update the Tuning Guide with info about Grant and Revoke. 

Revision 430492 committed patch derby1057_tuning4.diff, but one of two changes 
didn't make it.  The patch modified an existing file, tuningderby.ditamap, 
and that change was committed in r430492. The patch also added a new file,
rtunpropersqlauth.dita, which I forgot to 'svn add'. This commit adds the new 
file.

Patch by Laura Stewart <sc...@gmail.com>.

Added:
    db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita   (with props)

Added: db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita?rev=430928&view=auto
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita (added)
+++ db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita Fri Aug 11 17:18:56 2006
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--Arbortext, Inc., 1988-2005, v.4002-->
+<!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="rtunpropersqlauth" xml:lang="en-us">
+<title>derby.database.sqlAuthorization</title>
+<prolog><metadata>
+<keywords><indexterm>derby.database.sqlAuthorization</indexterm><indexterm>properties<indexterm>derby.database.sqlAuthorization</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><title>Function</title><p>One of the user authorization properties.</p><p>Enables
+the SQL standard authorization mode for the database or system on which this
+property is set. The possible values are:   <ul>
+<li><i>TRUE</i>   <p>SQL authorization for the database or system is enabled,
+which allows the use of GRANT and REVOKE statements. </p></li>
+<li><i>FALSE</i>   <p>SQL authorization for the database or system is disabled.
+After this property is set to TRUE, the property cannot be set back to FALSE.</p></li>
+</ul>The values are not case-sensitive.</p><note>If you set this property
+as a system property before you create the databases, all new databases will
+automatically have SQL authorization enabled. If the databases already exists,
+you can set this property only as a database property. </note><p><ph conref="tunconrefs.dita#prod/productshortname"></ph> uses
+the type of user authentication that is specified with the <codeph>derby.authentication.provider</codeph> property.</p><p>For
+more information about user authorization, see "User authorizations" in the <cite><ph
+conref="tunconrefs.dita#pub/citdevelop"></ph></cite>.</p> </section>
+<example><title>Example</title><codeblock><b><ph>-- system-wide property</ph>
+derby.database.sqlAuthorization=true</b></codeblock><codeblock><b><ph>-- database-level property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.database.sqlAuthorization', 'true');</b></codeblock></example>
+<section><title>Default</title><p><i>FALSE</i></p> </section>
+<section><title>Dynamic or static</title><p>Static. </p> </section>
+</refbody>
+</reference>

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