Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3137 SQL roles: add catalog support
  3. DERBY-3722

Add circularity check for the GRANT role statement

Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.5.1.1
    • Component/s: SQL
    • Labels:
      None
    • Bug behavior facts:
      Security

      Description

      When a role is granted to another role (with the GRANT <role> statement), we need to check that the grant relation does not give rise to a circularity. This is described in Section 12.5, Syntax rule 1 of ISO/IEC 9075-2 2003.

        Attachments

        1. derby-3722-1.diff
          38 kB
          Dag H. Wanvik
        2. derby-3722-1.stat
          1 kB
          Dag H. Wanvik
        3. derby-3722-2.diff
          39 kB
          Dag H. Wanvik
        4. derby-3722-2.stat
          1 kB
          Dag H. Wanvik
        5. derby-3722-3.diff
          40 kB
          Dag H. Wanvik
        6. derby-3722-3.stat
          1 kB
          Dag H. Wanvik

          Activity

            People

            • Assignee:
              dagw Dag H. Wanvik
              Reporter:
              dagw Dag H. Wanvik

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment