db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "ReferenceManualTenTwo" by YipNg
Date Tue, 03 Oct 2006 19:47:22 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by YipNg:
http://wiki.apache.org/db-derby/ReferenceManualTenTwo

------------------------------------------------------------------------------
  [[Anchor(systemtables)]]'''Derby System Tables: '''
  
  ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || SYSTABLEPERMS || http://db.apache.org/derby/docs/10.2/ref/rrefsistabssystableperms.html
|| Yip || In the column information for the SYSTABLEPERMS table's SELECTPRIV,DELETEPRIV,INSERTPRIV,UPDATEPRIV,
REFERENCEPRIV and TRIGGERPRIV column.  Their contents column should be:  The valid values
are y(non-grantable privilege),Y(grantable privilege) and N(no privilege). || ||
+ || SYSTABLEPERMS || http://db.apache.org/derby/docs/10.2/ref/rrefsistabssystableperms.html
|| Yip || In the column information for the SYSTABLEPERMS table's SELECTPRIV,DELETEPRIV,INSERTPRIV,UPDATEPRIV,
REFERENCEPRIV and TRIGGERPRIV column.  Their contents column should be:  The valid values
are 'y'(non-grantable privilege),'Y'(grantable privilege) and 'N'(no privilege). || ||
- || SYSCOLPERMS || http://db.apache.org/derby/docs/10.2/ref/rrefsistabssyscolperms.html ||
Yip || In the column information for the SYSCOLPERMS table's TYPE column.  Its content column
should be: 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.|| ||
+ || SYSCOLPERMS || http://db.apache.org/derby/docs/10.2/ref/rrefsistabssyscolperms.html ||
Yip || In the column information for the SYSCOLPERMS table's TYPE column.  Its content column
should be: If the privilege is non-grantable, the valid values are 's' for SELECT, 'u' for
UPDATE and 'r' for REFERENCES.  If the privilege is grantable, the valid values are 'S' for
SELECT, 'U' for UPDATE and 'R' for REFERENCES.|| ||
  
  [[Anchor(exceptionmessages)]]'''Derby exception messages and SQL States: '''
  

Mime
View raw message