[DERBY-1929] SYSTABLEPERMS and SYSCOLPERMS documentation needs to be updated

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.3.1.4
• Component/s: Documentation
• Assignee: Laura Stewart
• Reporter: Laura Stewart
• Created: 04/Oct/06 20:53
• Updated: 27/Mar/07 17:21
• Resolved: 22/Mar/07 02:41

Description

In the file http://db.apache.org/derby/docs/10.2/ref/rrefsistabssystableperms.html
title = SYSTABLEPERMS
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).

In the file http://db.apache.org/derby/docs/10.2/ref/rrefsistabssyscolperms.html
title = SYSCOLPERMS
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.