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

Syntax for GRANT table permission does not mention that several privileges may be specified in a list

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.4.1.3
    • 10.2.2.1, 10.3.2.1
    • Documentation
    • None

    Description

      The syntax is currently specified (in rrefsqljgrant) as:

      > GRANT privilege-type ON [TABLE]

      { table-Name | view-Name } TO grantees
      >
      > privilege-type
      >
      > { > ALL PRIVILEGES | > DELETE | > INSERT | > REFERENCES [column list] | > SELECT [column list] | > TRIGGER | > UPDATE [column list}
      > }

      Derby, however, accepts a list of privilege type (see code in
      sqlgrammar#tableActions), if the type is not "ALL PRIVILEGES".

      Furthermore, column-list is not expanded; it should be because it
      needs surrounding parentheses (i.e. it is not just a plain list).

      So, the doc for granting table permissions should read something like:

      Syntax for tables

      GRANT privilege-type ON [TABLE] { table-Name | view-Name }

      TO grantees

      privilege-type

      ALL PRIVILEGES |
      privilege-list

      privilege-list
      table-privilege

      {, table-privilege }

      *

      Table-privilege

      DELETE |
      INSERT |
      REFERENCES [column-list] |
      SELECT [column-list] |
      TRIGGER |
      UPDATE [column-list}

      column-list
      ( column-identifier

      {, column-identifier}

      * )

      Attachments

        1. derby3133_1.diff
          7 kB
          Laura Stewart
        2. derby3133_2.diff
          9 kB
          Laura Stewart
        3. derby3133_3.diff
          9 kB
          Laura Stewart
        4. derby3133_4.diff
          1 kB
          Laura Stewart
        5. rrefsqljgrant.dita
          7 kB
          Laura Stewart
        6. rrefsqljgrant.html
          10 kB
          Laura Stewart
        7. rrefsqljgrant.html
          10 kB
          Laura Stewart
        8. rrefsqljgrant-2.html
          10 kB
          Dag H. Wanvik
        9. rrefsqljrevoke.dita
          12 kB
          Laura Stewart
        10. rrefsqljrevoke.html
          17 kB
          Laura Stewart
        11. rrefsqljrevoke.html
          16 kB
          Laura Stewart
        12. rrefsqljrevoke-2.html
          17 kB
          Dag H. Wanvik

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            scotsmatrix Laura Stewart
            dagw Dag H. Wanvik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment