Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1929

SYSTABLEPERMS and SYSCOLPERMS documentation needs to be updated

    Details

    • 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
    • Labels:
      None

      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.

        Attachments

        1. derby1929.diff
          8 kB
          Laura Stewart
        2. rrefsistabssyscolperms.html
          7 kB
          Laura Stewart
        3. rrefsistabssystableperms.html
          9 kB
          Laura Stewart

          Activity

            People

            • Assignee:
              scotsmatrix Laura Stewart
              Reporter:
              scotsmatrix Laura Stewart
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: