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/15 22:58:23 UTC
svn commit: r431700 - /db/derby/docs/trunk/src/ref/
Author: jta
Date: Tue Aug 15 13:58:22 2006
New Revision: 431700
URL: http://svn.apache.org/viewvc?rev=431700&view=rev
Log:
DERBY-1057 (partial): Update the Reference Guide with info about Grant and
Revoke.
Patch (derby1057_ref4.diff) by Laura Stewart <sc...@gmail.com>.
Added:
db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita (with props)
db/derby/docs/trunk/src/ref/rrefsistabssysroutineperms.dita (with props)
db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita (with props)
db/derby/docs/trunk/src/ref/rrefsqljgrant.dita (with props)
db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita (with props)
Modified:
db/derby/docs/trunk/src/ref/refderby.ditamap
db/derby/docs/trunk/src/ref/rrefjdbc80004.dita
db/derby/docs/trunk/src/ref/rrefsistabs12085.dita
db/derby/docs/trunk/src/ref/rrefsistabs12813.dita
db/derby/docs/trunk/src/ref/rrefsistabs22441.dita
db/derby/docs/trunk/src/ref/rrefsistabs24045.dita
db/derby/docs/trunk/src/ref/rrefsistabs24269.dita
db/derby/docs/trunk/src/ref/rrefsistabs26665.dita
db/derby/docs/trunk/src/ref/rrefsistabs28114.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=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Tue Aug 15 13:58:22 2006
@@ -29,6 +29,27 @@
<vrmlist><vrm version="10"/></vrmlist>
<brand>Apache Derby</brand></prodinfo>
</topicmeta>
+<!--BELOW - This relationship table is not complete. There wasn't a reltable for the ref manual, so it was added for 10.2 to document the new SQL statements and to enable a link to the Dev Guide. Each topic (preferably in the order that they appear in the book) should be listed in the reltable and links added. The left side represents the source topic and the right side represents the topics that the source should link to.-->
+<reltable>
+<relrow>
+<relcell>
+<topicref href="rrefsqljgrant.dita" navtitle="GRANT statement "></topicref>
+</relcell>
+<relcell>
+<topicref href="rrefsqljrevoke.dita" navtitle="REVOKE statement "></topicref>
+</relcell>
+</relrow>
+<relrow>
+<relcell>
+<topicref href="rrefsqljrevoke.dita" navtitle="REVOKE statement "></topicref>
+</relcell>
+<relcell>
+<topicref href="../devguide/cdevcsecuregrantrevokeaccess.dita" navtitle="SQL standard authorization">
+</topicref>
+<topicref href="rrefsqljgrant.dita" navtitle="GRANT statement "></topicref>
+</relcell>
+</relrow>
+</reltable>
<topicref href="rrefcopyright.dita" navtitle="Copyright"></topicref>
<topicref collection-type="family" href="crefmpref1002477.dita" navtitle="About this guide">
<topicref href="crefmpref11181.dita" navtitle="Purpose of this document">
@@ -101,11 +122,13 @@
<topicref href="rrefsqlj42082.dita" navtitle="DROP TRIGGER statement"></topicref>
<topicref href="rrefsqlj61102.dita" navtitle="DROP VIEW statement"></topicref>
</topicref>
+<topicref href="rrefsqljgrant.dita" navtitle="GRANT statement"></topicref>
<topicref collection-type="family" href="crefsqljrenamestatements.dita" navtitle="RENAME statements">
<topicref href="rrefsqlj95598.dita" navtitle="RENAME INDEX statement"></topicref>
<topicref href="rrefsqljrenametablestatement.dita" navtitle="RENAME TABLE statement ">
</topicref>
</topicref>
+<topicref href="rrefsqljrevoke.dita" navtitle="REVOKE statement"></topicref>
<topicref collection-type="family" href="crefsqlj35312.dita" navtitle="SET statements">
<topicref href="rrefsqlj32268.dita" navtitle="SET SCHEMA statement"></topicref>
<topicref href="rrefsqlj41180.dita" navtitle="SET CURRENT ISOLATION statement">
@@ -319,6 +342,7 @@
<topicref collection-type="family" href="rrefsistabs38369.dita" navtitle="Derby System Tables">
<topicref href="rrefsistabs28114.dita" navtitle="SYSALIASES"></topicref>
<topicref href="rrefsistabs26665.dita" navtitle="SYSCHECKS"></topicref>
+<topicref href="rrefsistabssyscolperms.dita" navtitle="SYSCOLPERMS"></topicref>
<topicref href="rrefsistabs22441.dita" navtitle="SYSCOLUMNS"></topicref>
<topicref href="rrefsistabs39391.dita" navtitle="SYSCONGLOMERATES"></topicref>
<topicref href="rrefsistabs23241.dita" navtitle="SYSCONSTRAINTS"></topicref>
@@ -326,10 +350,13 @@
<topicref href="rrefsistabs40972.dita" navtitle="SYSFILES"></topicref>
<topicref href="rrefsistabs13420.dita" navtitle="SYSFOREIGNKEYS"></topicref>
<topicref href="rrefsistabs33921.dita" navtitle="SYSKEYS"></topicref>
+<topicref href="rrefsistabssysroutineperms.dita" navtitle="SYSROUTINEPERMS">
+</topicref>
<topicref href="rrefsistabs12085.dita" navtitle="SYSSCHEMAS"></topicref>
<topicref href="rrefsistabslilanguageitemsysstatistics.dita" navtitle="SYSSTATISTICS">
</topicref>
<topicref href="rrefsistabs33768.dita" navtitle="SYSSTATEMENTS"></topicref>
+<topicref href="rrefsistabssystableperms.dita" navtitle="SYSTABLEPERMS"></topicref>
<topicref href="rrefsistabs24269.dita" navtitle="SYSTABLES"></topicref>
<topicref href="rrefsistabs79888.dita" navtitle="SYSTRIGGERS"></topicref>
<topicref href="rrefsistabs24045.dita" navtitle="SYSVIEWS"></topicref>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc80004.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc80004.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc80004.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc80004.dita Tue Aug 15 13:58:22 2006
@@ -1,4 +1,5 @@
<?xml version="1.0" encoding="utf-8"?>
+
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
@@ -20,8 +21,8 @@
<reference id="rrefjdbc80004" xml:lang="en-us">
<title>java.sql.Connection </title>
<prolog><metadata>
-<keywords><indexterm>Scrollable insensitive cursors (JDBC)</indexterm><indexterm>Scrollable
-insensitive cursors</indexterm><indexterm>Cursors<indexterm>scrollable insensitive</indexterm></indexterm>
+<keywords><indexterm>Scrollable insensitive cursors (JDBC)</indexterm><indexterm>Scrollable
+ insensitive cursors</indexterm><indexterm>Cursors<indexterm>scrollable insensitive</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
@@ -55,7 +56,6 @@
the only result set types supported. If you request <i>TYPE_SCROLL_SENSITIVE</i>, <ph
conref="refconrefs.dita#prod/productshortname"></ph> issues an <i>SQLWarning</i> and
returns a <i>TYPE_SCROLL_INSENSITIVE ResultSet</i>. <p> These methods support
-both <i>ResultSet.CONCUR_READ_ONLY</i> and <i>ResultSet.CONCUR_UPDATABLE</i> concurrencies.
-</p></section>
+both <i>ResultSet.CONCUR_READ_ONLY</i> and <i>ResultSet.CONCUR_UPDATABLE</i> concurrencies. </p></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs12085.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs12085.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs12085.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs12085.dita Tue Aug 15 13:58:22 2006
@@ -21,8 +21,8 @@
<reference id="rrefsistabs12085" xml:lang="en-us">
<title>SYSSCHEMAS</title>
<refbody>
-<section><p>Describes the schemas within the current database. <table pgwide="1"
-frame="all">
+<section><p>Describes the schemas within the current database.
+<table pgwide="1" frame="all">
<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="26*"/>
<colspec colname="2" colnum="2" colwidth="15*"/><colspec colname="3" colnum="3"
colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
Modified: db/derby/docs/trunk/src/ref/rrefsistabs12813.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs12813.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs12813.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs12813.dita Tue Aug 15 13:58:22 2006
@@ -1,4 +1,5 @@
<?xml version="1.0" encoding="utf-8"?>
+
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
@@ -19,12 +20,15 @@
-->
<reference id="rrefsistabs12813" xml:lang="en-us">
<title>SYSDEPENDS</title>
+<shortdesc>The SYSDEPENDS table stores the dependency relationships between
+persistent objects in the database.</shortdesc>
<refbody>
-<section><p>Describes the dependency relationships between persistent objects
-in the database. Persistent objects can be dependents (they depend on other
-objects) and/or providers (other objects depend on them).</p></section>
-<section><p>Providers are tables, conglomerates, and constraints. Dependents
-are views. <table pgwide="1" frame="all">
+<section><p>Persistent objects can be dependents or providers. Dependents
+are objects that depend on other objects. Providers are objects that other
+objects depend on. <ul>
+<li>Dependents are views, constraints, or triggers.</li>
+<li>Providers are tables, conglomerates, constraints, or privileges.</li>
+</ul></p><p><table frame="all" pgwide="1">
<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="28*"/>
<colspec colname="2" colnum="2" colwidth="24*"/><colspec colname="3" colnum="3"
colwidth="11*"/><colspec colname="4" colnum="4" colwidth="13*"/><colspec colname="5"
@@ -44,7 +48,7 @@
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the dependent</entry>
+<entry colname="5">A uunique identifier for the dependent.</entry>
</row>
<row>
<entry colname="1">DEPENDENTFINDER</entry>
@@ -52,14 +56,15 @@
is not part of the public API.</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">system type describing the view</entry>
+<entry colname="5">A system type that describes the view, constraint, or trigger
+that is the dependent.</entry>
</row>
<row>
<entry colname="1">PROVIDERID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the provider</entry>
+<entry colname="5">A unique identifier for the provider.</entry>
</row>
<row>
<entry colname="1">PROVIDERFINDER</entry>
@@ -67,8 +72,8 @@
not part of the public API.</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">system type describing the tables, conglomerates, and constraints
-that are providers</entry>
+<entry colname="5">A system type that describes the table, conglomerate, constraint,
+and privilege that is the provider</entry>
</row>
</tbody>
</tgroup>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs22441.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs22441.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs22441.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs22441.dita Tue Aug 15 13:58:22 2006
@@ -21,7 +21,7 @@
<title>SYSCOLUMNS</title>
<refbody>
<section><p>Describes the columns within all tables in the current database:
- <table pgwide="1" frame="all">
+<table pgwide="1" frame="all">
<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="29*"/>
<colspec colname="2" colnum="2" colwidth="23*"/><colspec colname="3" colnum="3"
colwidth="10*"/><colspec colname="4" colnum="4" colwidth="11*"/><colspec colname="5"
Modified: db/derby/docs/trunk/src/ref/rrefsistabs24045.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs24045.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs24045.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs24045.dita Tue Aug 15 13:58:22 2006
@@ -1,4 +1,7 @@
<?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
@@ -15,9 +18,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefsistabs24045" xml:lang="en-us">
<title>SYSVIEWS</title>
<refbody>
@@ -71,4 +71,3 @@
</table></p></section>
</refbody>
</reference>
-
Modified: db/derby/docs/trunk/src/ref/rrefsistabs24269.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs24269.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs24269.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs24269.dita Tue Aug 15 13:58:22 2006
@@ -1,4 +1,7 @@
<?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
@@ -15,9 +18,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefsistabs24269" xml:lang="en-us">
<title>SYSTABLES</title>
<refbody>
@@ -84,4 +84,3 @@
</table></p></section>
</refbody>
</reference>
-
Modified: db/derby/docs/trunk/src/ref/rrefsistabs26665.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs26665.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs26665.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs26665.dita Tue Aug 15 13:58:22 2006
@@ -22,7 +22,7 @@
<title>SYSCHECKS</title>
<refbody>
<section><p>Describes the check constraints within the current database.
- <table pgwide="1" frame="all">
+<table pgwide="1" frame="all">
<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
<colspec colname="2" colnum="2" colwidth="24*"/><colspec colname="3" colnum="3"
colwidth="9*"/><colspec colname="4" colnum="4" colwidth="13*"/><colspec colname="5"
Modified: db/derby/docs/trunk/src/ref/rrefsistabs28114.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs28114.dita?rev=431700&r1=431699&r2=431700&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs28114.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs28114.dita Tue Aug 15 13:58:22 2006
@@ -1,4 +1,5 @@
<?xml version="1.0" encoding="utf-8"?>
+
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
Added: db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita?rev=431700&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita Tue Aug 15 13:58:22 2006
@@ -0,0 +1,100 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefsistabssyscolperms" xml:lang="en-us">
+<title>SYSCOLPERMS</title>
+<shortdesc>The SYSCOLPERMS table stores the column permissions that have been
+granted but not revoked.</shortdesc>
+<refbody>
+<section><p>All of the permissions for one (GRANTEE, TABLEID, TYPE, GRANTOR)
+combination are specified in a single row in the SYSCOLPERMS table. The keys
+for the SYSCOLPERMS table are: <ul>
+<li>Primary key (GRANTEE, TABLEID, TYPE, GRANTOR)</li>
+<li>Unique key (COLPERMSID)</li>
+<li>Foreign key (TABLEID references SYS.SYSTABLES)</li>
+</ul> </p></section>
+<table frame="all" pgwide="1">
+<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
+<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
+colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
+colnum="5" colwidth="38*"/>
+<thead>
+<row>
+<entry align="left" colname="1" valign="bottom">Column Name</entry>
+<entry align="left" colname="2" valign="bottom">Type</entry>
+<entry align="left" colname="3" valign="bottom">Length</entry>
+<entry align="left" colname="4" valign="bottom">Nullability</entry>
+<entry align="left" colname="5" valign="bottom">Contents</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="1">COLPERMSID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Used by the dependency manager to track the dependency
+of a view, trigger, or constraint on the column level permissions.</entry>
+</row>
+<row>
+<entry colname="1">GRANTEE</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The authorization ID of the user to whom the privilege
+was granted. </entry>
+</row>
+<row>
+<entry colname="1">GRANTOR</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The authorization ID of the user who granted the privilege.
+Privileges can be granted only by the object owner.</entry>
+</row>
+<row>
+<entry colname="1">TABLEID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The unique identifier for the table on which the permissions
+have been granted.</entry>
+</row>
+<row>
+<entry colname="1">TYPE</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The type of column permission: <lines><i>S</i> for SELECT
+<i>U</i> for UPDATE
+<i>R</i> for REFERENCES</lines></entry>
+</row>
+<row>
+<entry colname="1">COLUMNS</entry>
+<entry colname="2">org.apache.derby.iapi.services.io.FormatableBitSet </entry>
+<entry colname="3"></entry>
+<entry colname="4">false</entry>
+<entry colname="5">A list of columns to which the privilege applies.<p>This
+class is not part of the public API.</p></entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita
------------------------------------------------------------------------------
svn:eol-style = native
Added: db/derby/docs/trunk/src/ref/rrefsistabssysroutineperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabssysroutineperms.dita?rev=431700&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabssysroutineperms.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsistabssysroutineperms.dita Tue Aug 15 13:58:22 2006
@@ -0,0 +1,91 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefsistabssysroutineperms" xml:lang="en-us">
+<title>SYSROUTINEPERMS</title>
+<shortdesc>The SYSROUTINEPERMS table stores the permissions that have been
+granted to routines.</shortdesc>
+<refbody>
+<section><p>Each routine EXECUTE permission is specified in a row in the SYSROUTINEPERMS
+table. The keys for the SYSROUTINEPERMS table are: <ul>
+<li>Primary key (GRANTEE, ALIASID, GRANTOR)</li>
+<li>Unique key (ROUTINEPERMSID)</li>
+<li>Foreign key (ALIASID references SYS.SYSALIASES)</li>
+</ul> </p><p>The column information for the SYSTABLEPERMS table is listed
+in the following table:</p><table frame="all" pgwide="1">
+<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
+<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
+colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
+colnum="5" colwidth="38*"/>
+<thead>
+<row>
+<entry align="left" colname="1" valign="bottom">Column Name</entry>
+<entry align="left" colname="2" valign="bottom">Type</entry>
+<entry align="left" colname="3" valign="bottom">Length</entry>
+<entry align="left" colname="4" valign="bottom">Nullability</entry>
+<entry align="left" colname="5" valign="bottom">Contents</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="1">ROUTINEPERMSID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Used by the dependency manager to track the dependency
+of a view, trigger, or constraint on the routine level permissions.</entry>
+</row>
+<row>
+<entry colname="1">GRANTEE</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The authorization ID of the user to whom the privilege
+is granted.</entry>
+</row>
+<row>
+<entry colname="1">GRANTOR</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The authorization ID of the user who granted the privilege.
+Privileges can be granted only by the object owner.</entry>
+</row>
+<row>
+<entry colname="1">ALIASID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The ID of the object of the required permission. If PERMTYPE='E'
+the ALIASID is a reference to the SYS.SYSALIASES table. Otherwise the ALIASID
+is a reference to the SYS.SYSTABLES table.</entry>
+</row>
+<row>
+<entry colname="1">GRANTOPTION</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Specifies if the GRANTEE is the owner of the routine. Valid
+values are Y and N.</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefsistabssysroutineperms.dita
------------------------------------------------------------------------------
svn:eol-style = native
Added: db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita?rev=431700&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita Tue Aug 15 13:58:22 2006
@@ -0,0 +1,131 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefsistabssystableperms" xml:lang="en-us">
+<title>SYSTABLEPERMS</title>
+<shortdesc>The SYSTABLEPERMS table stores the table permissions that have
+been granted but not revoked.</shortdesc>
+<refbody>
+<section><p>All of the permissions for one (GRANTEE, TABLEID, GRANTOR) combination
+are specified in a single row in the SYSTABLEPERMS table. The keys for the
+SYSTABLEPERMS table are: <ul>
+<li>Primary key (GRANTEE, TABLEID, GRANTOR)</li>
+<li>Unique key (TABLEPERMSID)</li>
+<li>Foreign key (TABLEID references SYS.SYSTABLES)</li>
+</ul> </p><p>The column information for the SYSTABLEPERMS table is listed
+in the following table:</p><table frame="all" pgwide="1">
+<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
+<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
+colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
+colnum="5" colwidth="38*"/>
+<thead>
+<row>
+<entry align="left" colname="1" valign="bottom">Column Name</entry>
+<entry align="left" colname="2" valign="bottom">Type</entry>
+<entry align="left" colname="3" valign="bottom">Length</entry>
+<entry align="left" colname="4" valign="bottom">Nullability</entry>
+<entry align="left" colname="5" valign="bottom">Contents</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="1">TABLEPERMSID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Used by the dependency manager to track the dependency
+of a view, trigger, or constraint on the table level permissions.</entry>
+</row>
+<row>
+<entry colname="1">GRANTEE</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The authorization ID of the user to whom the privilege
+is granted.</entry>
+</row>
+<row>
+<entry colname="1">GRANTOR</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The authorization ID of the user who granted the privilege.
+Privileges can be granted only by the object owner.</entry>
+</row>
+<row>
+<entry colname="1">TABLEID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The unique identifier for the table on which the permissions
+have been granted.</entry>
+</row>
+<row>
+<entry colname="1">SELECTPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Specifies if the SELECT permission is granted. Valid values
+are Y and N.</entry>
+</row>
+<row>
+<entry colname="1">DELETEPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Specifies if the DELETE permission is granted. Valid values
+are Y and N.</entry>
+</row>
+<row>
+<entry colname="1">INSERTPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Specifies if the INSERT permission is granted. Valid values
+are Y and N.</entry>
+</row>
+<row>
+<entry colname="1">UPDATEPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Specifies if the UPDATE permission is granted. Valid values
+are Y and N.</entry>
+</row>
+<row>
+<entry colname="1">REFERENCEPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Specifies if the REFERENCE permission is granted. Valid
+values are Y and N.</entry>
+</row>
+<row>
+<entry colname="1">TRIGGERPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">false</entry>
+<entry colname="5">Specifies if the TRIGGER permission is granted. Valid values
+are Y and N.</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita
------------------------------------------------------------------------------
svn:eol-style = native
Added: db/derby/docs/trunk/src/ref/rrefsqljgrant.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljgrant.dita?rev=431700&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljgrant.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsqljgrant.dita Tue Aug 15 13:58:22 2006
@@ -0,0 +1,95 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefsqljgrant" xml:lang="en-us">
+<title>GRANT statement </title>
+<shortdesc>Use the GRANT statement to give permissions to a specific user
+or all users to perform actions on database objects.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>GRANT statement</indexterm><indexterm>SQL statements<indexterm>GRANT</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The following types of permissions can be granted:<ul>
+<li>Delete data from a specific table.</li>
+<li>Insert data into a specific table.</li>
+<li>Create a foreign key reference to the named table or to a subset of columns
+from a table.</li>
+<li>Select data from a table, view, or a subset of columns in a table.</li>
+<li>Create a trigger on a table.</li>
+<li>Update data in a table or in a subset of columns in a table.</li>
+<li>Run a specified function or procedure.</li>
+</ul></p><p>When a table, view, function, or procedure is created, only the
+object owner has full privileges on the object. No other users have any privileges
+on the object until the object owner grants privileges to the users. </p><p>The
+syntax that you use for the GRANT statement depends on whether you are granting
+privileges to a table or to a routine.</p></section>
+<section><title>Syntax for tables</title><codeblock><b>GRANT <i><xref href="rrefsqljgrant.dita#rrefsqljgrant/grantprivtype">privilege-type</xref></i
+> ON [TABLE] { <i><xref href="rreftablename.dita#rreftablename"></xref></i> | <i><xref
+href="rrefviewname.dita#rrefviewname"></xref></i> } TO <i><xref href="rrefsqljgrant.dita#rrefsqljgrant/grantgrantees">grantees</xref></i></b></codeblock
+></section>
+<section><title>Syntax for routines</title><codeblock><b>GRANT EXECUTE ON { FUNCTION | PROCEDURE } <i><xref
+href="rrefsqljgrant.dita#rrefsqljgrant/grantroutinename">routine-designator</xref></i> TO <i><xref
+href="rrefsqljgrant.dita#rrefsqljgrant/grantgrantees">grantees</xref></i></b></codeblock></section>
+<section id="grantprivtype"><title>privilege-type</title><codeblock><b>
+ {
+ ALL PRIVILEGES |
+ DELETE |
+ INSERT |
+ REFERENCES [<i>column list</i>] |
+ SELECT [<i>column list</i>] |
+ TRIGGER |
+ UPDATE [<i>column list</i>}
+ }</b></codeblock><p>Use the DELETE privilege type to grant permission to
+delete rows from the specified table.</p><p>Use the INSERT privilege type
+to grant permission to insert rows into the specified table.</p><p>Use the
+REFERENCES privilege type to grant permission to create a foreign key reference
+to the specified table. If a column list is specified with the REFERENCES
+privilege, the permission is valid on only the foreign key reference to the
+specified columns.</p><p>Use the SELECT privilege type to grant permission
+to perform SELECT statements on a table or view. If a column list is specified
+with the SELECT privilege, the permission is valid on only those columns.
+If no column list is specified, then the privilege is valid on all of the
+columns in the table.</p><p>Use the TRIGGER privilege type to grant permission
+to create a trigger on the specified table.</p><p>Use the UPDATE privilege
+type to grant permission to use the UPDATE statement on the specified table.
+If a column list is specified, the permission applies only to the specified
+columns.</p></section>
+<section id="grantgrantees"><title>grantees</title><codeblock><b>{ <i>authorization ID</i> | PUBLIC } [,{ <i>authorization ID</i> | PUBLIC } ] *</b
+></codeblock><p>You can grant privileges for specific users or for all users.
+Use the keyword PUBLIC to specify all users. When PUBLIC is specified, the
+privileges affect all current and future users. The privileges granted to
+PUBLIC and to individual users are independent privileges. For example, a
+SELECT privilege on table <codeph>t</codeph> is granted to both PUBLIC and
+to the authorization ID <codeph>harry</codeph>. The SELECT privilege is later
+revoked from the authorization ID <codeph>harry</codeph>, but Harry can access
+the table <codeph>t</codeph> through the PUBLIC privilege.</p></section>
+<section id="grantroutinename"><title>routine-designator</title><codeblock><b>{
+ <i>function-name</i> | <i>procedure-name</i>
+}</b></codeblock></section>
+<example id="grantexamples"><title>Examples</title><p>To grant the SELECT
+privilege on table t to the authorization IDs <codeph>maria</codeph> and <codeph>harry</codeph>,
+use the following syntax:<codeblock><b>GRANT SELECT ON TABLE t TO maria,harry</b> </codeblock></p><p>To
+grant the UPDATE and TRIGGER privileges on table t to the authorization IDs <codeph>anita</codeph> and <codeph>zhi</codeph>,
+use the following syntax:<codeblock><b>GRANT UPDATE, TRIGGER ON TABLE t TO anita,zhi</b> </codeblock></p><p>To
+grant the SELECT privilege on table s.v to all users, use the following syntax:<codeblock><b>GRANT SELECT ON TABLE s.v to PUBLIC</b></codeblock></p
+><p>To grant the EXECUTE privilege on procedure p to the authorization ID <codeph>george</codeph>,
+use the following syntax:</p><codeblock><b>GRANT EXECUTE ON PROCEDURE p TO george</b> </codeblock></example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefsqljgrant.dita
------------------------------------------------------------------------------
svn:eol-style = native
Added: db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita?rev=431700&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita Tue Aug 15 13:58:22 2006
@@ -0,0 +1,110 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefsqljrevoke" xml:lang="en-us">
+<title>REVOKE statement </title>
+<shortdesc>Use the REVOKE statement to remove permissions from a specific
+user or from all users to perform actions on database objects.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>REVOKE statement</indexterm><indexterm>SQL statements<indexterm>REVOKE</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The following types of permissions can be revoked:<ul>
+<li>Delete a specific table.</li>
+<li>Insert data into a specific table.</li>
+<li>Create a foreign key reference to the named table or to a subset of columns
+from a table.</li>
+<li>Select data from a table, view, or a subset of columns in a table.</li>
+<li>Create a trigger on a table.</li>
+<li>Update data in a table or in a subset of columns in a table.</li>
+<li>Run a specified routine (function or procedure).</li>
+</ul></p><p>Only the owner of an object can revoke privileges from an object.</p><p>The
+syntax that you use for the REVOKE statement depends on whether you are revoking
+privileges to a table or to a routine.</p></section>
+<section><title>Syntax for tables</title><codeblock><b>REVOKE <i><xref href="rrefsqljrevoke.dita#rrefsqljrevoke/revokeptype">privilege-type</xref
+></i> ON [ TABLE ] { <i><xref href="rreftablename.dita#rreftablename"></xref></i> | <i><xref
+href="rrefviewname.dita#rrefviewname"></xref></i> } FROM <i><xref href="rrefsqljrevoke.dita#rrefsqljrevoke/revokegrantees">grantees</xref></i></b
+></codeblock><p>Revoking a privilege without specifying a column list revokes
+the privilege for all of the columns in the table. </p></section>
+<section><title>Syntax for routines</title><codeblock><b>REVOKE EXECUTE ON { FUNCTION | PROCEDURE } <i><xref
+href="rrefsqljrevoke.dita#rrefsqljrevoke/revokeroutinename">routine-designator</xref></i> FROM <i><xref
+href="rrefsqljrevoke.dita#rrefsqljrevoke/revokegrantees">grantees</xref> </i> RESTRICT</b></codeblock><p>You
+must use the RESTRICT clause on REVOKE statements for routines. The RESTRICT
+clause specifies that the EXECUTE privilege cannot be revoked if the specified
+routine is used in a view, trigger, or constraint, and the privilege is being
+revoked from the owner of the view, trigger, or constraint.</p></section>
+<section id="revokeptype"><title>privilege-type</title><codeblock><b>
+ {
+ ALL PRIVILEGES |
+ DELETE |
+ INSERT |
+ REFERENCES [<i>column list</i>] |
+ SELECT [<i>column list</i>] |
+ TRIGGER |
+ UPDATE [<i>column list</i>}
+ }</b></codeblock><p>Use the ALL PRIVILEGES privilege type to revoke all of
+the permissions from the user for the specified table.</p><p>Use the DELETE
+privilege type to revoke permission to delete rows from the specified table.</p><p>Use
+the INSERT privilege type to revoke permission to insert rows into the specified
+table.</p><p>Use the REFERENCES privilege type to revoke permission to create
+a foreign key reference to the specified table. If a column list is specified
+with the REFERENCES privilege, the permission is revoked on only the foreign
+key reference to the specified columns.</p><p>Use the SELECT privilege type
+to revoke permission to perform SELECT statements on a table or view. If a
+column list is specified with the SELECT privilege, the permission is revoked
+on only those columns. If no column list is specified, then the privilege
+is valid on all of the columns in the table.</p><p>Use the TRIGGER privilege
+type to revoke permission to create a trigger on the specified table.</p><p>Use
+the UPDATE privilege type to revoke permission to use the UPDATE statement
+on the specified table. If a column list is specified, the permission is revoked
+only on the specified columns.</p></section>
+<section id="revokegrantees"><title>grantees</title><codeblock><b>{ <i>authorization ID</i> | PUBLIC } [,{ <i>authorization ID</i> | PUBLIC } ] *</b
+></codeblock><p>You can revoke the privileges from specific users or from
+all users. Use the keyword PUBLIC to specify all users. When PUBLIC is specified,
+the privileges affect all current and future users. The privileges revoked
+from PUBLIC and to individual users are independent privileges. For example,
+a SELECT privilege on table <codeph>t</codeph> is granted to both PUBLIC and
+to the authorization ID <codeph>harry</codeph>. The SELECT privilege is later
+revoked from the authorization ID <codeph>harry</codeph>, but Harry can access
+the table <codeph>t</codeph> through the PUBLIC privilege.</p><note type="restriction">You
+cannot revoke the privileges of the owner of an object.</note></section>
+<section id="revokeroutinename"><title>routine-designator</title><codeblock><b>
+ {
+ <i>qualified-name</i> [ signature ]
+ }</b></codeblock></section>
+<section><title>Cascading object dependencies</title><p>For views, triggers,
+and constraints, if the privilege on which the object depends on is revoked,
+the object is automatically dropped. <ph conref="refconrefs.dita#prod/productshortname"></ph> does
+not try to determine if you have other privileges that can replace the privileges
+that are being revoked. For more information, see "SQL standard authorization"
+in the <ph conref="refconrefs.dita#pub/citdevelop">Derby Developer's Guide</ph>.</p></section>
+<example> <title>Revoke examples</title><p>To revoke the SELECT privilege
+on table t from the authorization IDs <codeph>maria</codeph> and <codeph>harry</codeph>,
+use the following syntax:<codeblock><b>REVOKE SELECT ON TABLE t FROM maria,harry</b> </codeblock></p><p>To
+revoke the UPDATE and TRIGGER privileges on table t from the authorization
+IDs <codeph>anita</codeph> and <codeph>zhi</codeph>, use the following syntax:<codeblock><b>REVOKE UPDATE, TRIGGER ON TABLE t FROM anita,zhi</b> </codeblock
+></p><p>To revoke the SELECT privilege on table s.v from all users, use the
+following syntax:<codeblock><b>REVOKE SELECT ON TABLE s.v FROM PUBLIC</b></codeblock></p><p>To
+revoke the UPDATE privilege on columns c1 and c2 of table s.v from all users,
+use the following syntax:<codeblock><b>REVOKE UPDATE (c1,c2) ON TABLE s.v FROM PUBLIC</b></codeblock></p><p>To
+revoke the EXECUTE privilege on procedure p from the authorization ID <codeph>george</codeph>,
+use the following syntax:</p><codeblock><b>REVOKE EXECUTE ON PROCEDURE p FROM george RESTRICT</b> </codeblock></example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita
------------------------------------------------------------------------------
svn:eol-style = native