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/03/22 03:41:30 UTC
svn commit: r521090 - in /db/derby/docs/trunk/src/ref:
rrefsistabssyscolperms.dita rrefsistabssystableperms.dita
Author: scotsmatrix
Date: Wed Mar 21 19:41:29 2007
New Revision: 521090
URL: http://svn.apache.org/viewvc?view=rev&rev=521090
Log:
DERBY-1929: Updated the valid values for the SYSTABLEPERMS and SYSCOLPERMS topics. Patch was contributed by me.
Modified:
db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita
db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita
Modified: db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita?view=diff&rev=521090&r1=521089&r2=521090
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita Wed Mar 21 19:41:29 2007
@@ -24,6 +24,11 @@
<title>SYSCOLPERMS system table</title>
<shortdesc>The SYSCOLPERMS table stores the column permissions that have been
granted but not revoked.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSCOLPERMS</indexterm></indexterm>
+<indexterm>permissions<indexterm>SYSCOLPERMS system table</indexterm></indexterm>
+<indexterm>SYSCOLPERMS system table</indexterm></keywords>
+</metadata></prolog>
<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
@@ -51,7 +56,7 @@
<entry colname="1">COLPERMSID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">false</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>
@@ -59,7 +64,7 @@
<entry colname="1">GRANTEE</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">30</entry>
-<entry colname="4">false</entry>
+<entry colname="4">False</entry>
<entry colname="5">The authorization ID of the user to whom the privilege
was granted. </entry>
</row>
@@ -67,7 +72,7 @@
<entry colname="1">GRANTOR</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">30</entry>
-<entry colname="4">false</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>
@@ -75,7 +80,7 @@
<entry colname="1">TABLEID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">false</entry>
+<entry colname="4">False</entry>
<entry colname="5">The unique identifier for the table on which the permissions
have been granted.</entry>
</row>
@@ -83,16 +88,19 @@
<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>
+<entry colname="4">False</entry>
+<entry colname="5">If the privilege is non-grantable, the valid values are: <lines>'s' for SELECT
+'u' for UPDATE
+'r' for REFERENCES
+</lines>If the privilege is grantable, the valid values are: <lines>'S' for SELECT
+'U' for UPDATE
+'R' 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="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>
Modified: db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita?view=diff&rev=521090&r1=521089&r2=521090
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita Wed Mar 21 19:41:29 2007
@@ -24,6 +24,11 @@
<title>SYSTABLEPERMS system table</title>
<shortdesc>The SYSTABLEPERMS table stores the table permissions that have
been granted but not revoked.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSTABLEPERMS</indexterm></indexterm>
+<indexterm>permissions<indexterm>SYSTABLEPERMS system table</indexterm></indexterm>
+<indexterm>SYSTABLEPERMS system table</indexterm></keywords>
+</metadata></prolog>
<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
@@ -51,7 +56,7 @@
<entry colname="1">TABLEPERMSID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">false</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>
@@ -59,7 +64,7 @@
<entry colname="1">GRANTEE</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">30</entry>
-<entry colname="4">false</entry>
+<entry colname="4">False</entry>
<entry colname="5">The authorization ID of the user to whom the privilege
is granted.</entry>
</row>
@@ -67,7 +72,7 @@
<entry colname="1">GRANTOR</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">30</entry>
-<entry colname="4">false</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>
@@ -75,7 +80,7 @@
<entry colname="1">TABLEID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">false</entry>
+<entry colname="4">False</entry>
<entry colname="5">The unique identifier for the table on which the permissions
have been granted.</entry>
</row>
@@ -83,49 +88,60 @@
<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>
+<entry colname="4">False</entry>
+<entry colname="5">Specifies if the SELECT permission is granted. The valid
+values are: <lines>'y' (non-grantable privilege)
+'Y' (grantable privilege)
+'N' (no privilege)</lines></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>
+<entry colname="4">False</entry>
+<entry colname="5">Specifies if the DELETE permission is granted. The valid
+values are: <lines>'y' (non-grantable privilege)
+'Y' (grantable privilege)
+'N' (no privilege)</lines></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>
+<entry colname="4">False</entry>
+<entry colname="5">Specifies if the INSERT permission is granted. <lines>'y' (non-grantable privilege)
+'Y' (grantable privilege)
+'N' (no privilege)</lines></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>
+<entry colname="4">False</entry>
+<entry colname="5">Specifies if the UPDATE permission is granted. The valid
+values are: <lines>'y' (non-grantable privilege)
+'Y' (grantable privilege)
+'N' (no privilege)</lines></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>
+<entry colname="4">False</entry>
+<entry colname="5">Specifies if the REFERENCE permission is granted. The valid
+values are: <lines>'y' (non-grantable privilege)
+'Y' (grantable privilege)
+'N' (no privilege)</lines></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>
+<entry colname="4">False</entry>
+<entry colname="5">Specifies if the TRIGGER permission is granted. The valid
+values are: <lines>'y' (non-grantable privilege)
+'Y' (grantable privilege)
+'N' (no privilege)</lines></entry>
</row>
</tbody>
</tgroup>