SYSCOLPERMS system table

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 @@ COLPERMSID CHAR 36 -false +False Used by the dependency manager to track the dependency of a view, trigger, or constraint on the column level permissions. @@ -59,7 +64,7 @@ GRANTEE VARCHAR 30 -false +False The authorization ID of the user to whom the privilege was granted. @@ -67,7 +72,7 @@ GRANTOR VARCHAR 30 -false +False The authorization ID of the user who granted the privilege. Privileges can be granted only by the object owner. @@ -75,7 +80,7 @@ TABLEID CHAR 36 -false +False The unique identifier for the table on which the permissions have been granted. @@ -83,16 +88,19 @@ TYPE CHAR 1 -false -The type of column permission: S for SELECT -U for UPDATE -R for REFERENCES +False +If the privilege is non-grantable, the valid values are: 's' for SELECT +'u' for UPDATE +'r' for REFERENCES +If the privilege is grantable, the valid values are: 'S' for SELECT +'U' for UPDATE +'R' for REFERENCES COLUMNS org.apache.derby.iapi.services.io.FormatableBitSet -false +False A list of columns to which the privilege applies.

This class is not part of the public API.

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 @@ SYSTABLEPERMS system table The SYSTABLEPERMS table stores the table permissions that have been granted but not revoked. + +system tablesSYSTABLEPERMS +permissionsSYSTABLEPERMS system table +SYSTABLEPERMS system table +

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 @@ TABLEPERMSID CHAR 36 -false +False Used by the dependency manager to track the dependency of a view, trigger, or constraint on the table level permissions. @@ -59,7 +64,7 @@ GRANTEE VARCHAR 30 -false +False The authorization ID of the user to whom the privilege is granted. @@ -67,7 +72,7 @@ GRANTOR VARCHAR 30 -false +False The authorization ID of the user who granted the privilege. Privileges can be granted only by the object owner. @@ -75,7 +80,7 @@ TABLEID CHAR 36 -false +False The unique identifier for the table on which the permissions have been granted. @@ -83,49 +88,60 @@ SELECTPRIV CHAR 1 -false -Specifies if the SELECT permission is granted. Valid values -are Y and N. +False +Specifies if the SELECT permission is granted. The valid +values are: 'y' (non-grantable privilege) +'Y' (grantable privilege) +'N' (no privilege) DELETEPRIV CHAR 1 -false -Specifies if the DELETE permission is granted. Valid values -are Y and N. +False +Specifies if the DELETE permission is granted. The valid +values are: 'y' (non-grantable privilege) +'Y' (grantable privilege) +'N' (no privilege) INSERTPRIV CHAR 1 -false -Specifies if the INSERT permission is granted. Valid values -are Y and N. +False +Specifies if the INSERT permission is granted. 'y' (non-grantable privilege) +'Y' (grantable privilege) +'N' (no privilege) UPDATEPRIV CHAR 1 -false -Specifies if the UPDATE permission is granted. Valid values -are Y and N. +False +Specifies if the UPDATE permission is granted. The valid +values are: 'y' (non-grantable privilege) +'Y' (grantable privilege) +'N' (no privilege) REFERENCEPRIV CHAR 1 -false -Specifies if the REFERENCE permission is granted. Valid -values are Y and N. +False +Specifies if the REFERENCE permission is granted. The valid +values are: 'y' (non-grantable privilege) +'Y' (grantable privilege) +'N' (no privilege) TRIGGERPRIV CHAR 1 -false -Specifies if the TRIGGER permission is granted. Valid values -are Y and N. +False +Specifies if the TRIGGER permission is granted. The valid +values are: 'y' (non-grantable privilege) +'Y' (grantable privilege) +'N' (no privilege)