Derby
  1. Derby
  2. DERBY-4161

SQL Roles - Clarify documentation regarding the SET ROLE

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.5.2.0, 10.6.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      After discussing this issue on the mailing list, it has been agreed that the documentation regarding the usage of SQL roles needs to be clarified.

      Namely, it should be clearer that a session does not have a role set by default and that as such, a SET ROLE must be issued to enable a specific role.

      Further along the path, we may want to have the ability of setting a default role but for now and for the release of 10.5 this is the shortest and best course to follow.

      Kim had already suggested an addition to the documentation on the list; maybe she'd like to take on this issue?

      1. cdevcsecureroles.html
        13 kB
        Kim Haase
      2. DERBY-4161-2.diff
        5 kB
        Kim Haase
      3. cdevcsecureroles.html
        13 kB
        Kim Haase
      4. DERBY-4161.diff
        5 kB
        Kim Haase

        Issue Links

          Activity

          Tiago R. Espinha created issue -
          Tiago R. Espinha made changes -
          Field Original Value New Value
          Description After discussing this issue on the mailing list, it has been agreed that the documentation regarding the usage of SQL roles needs to be clarified.

          Namely, it should be clearer that a session does not have a role set by default and that as such, a SET ROLE needs to be issued to enable a specific role.

          Further along the path, we may want to have the ability of setting a default role but for now and for the release of 10.5 this is the shortest and best course to follow.

          Kim had already suggested an addition to the documentation on the list; maybe she'd like to take on this issue?
          After discussing this issue on the mailing list, it has been agreed that the documentation regarding the usage of SQL roles needs to be clarified.

          Namely, it should be clearer that a session does not have a role set by default and that as such, a SET ROLE must be issued to enable a specific role.

          Further along the path, we may want to have the ability of setting a default role but for now and for the release of 10.5 this is the shortest and best course to follow.

          Kim had already suggested an addition to the documentation on the list; maybe she'd like to take on this issue?
          Tiago R. Espinha made changes -
          Link This issue is related to DERBY-4162 [ DERBY-4162 ]
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Kim Haase made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Fix Version/s 10.5.1.0 [ 12313770 ]
          Fix Version/s 10.5.1.1 [ 12313771 ]
          Fix Version/s 10.5.1.2 [ 12313870 ]
          Affects Version/s 10.5.1.1 [ 12313771 ]
          Kim Haase made changes -
          Attachment DERBY-4161.diff [ 12405544 ]
          Attachment cdevcsecureroles.html [ 12405545 ]
          Kim Haase made changes -
          Derby Info [Patch Available]
          Kim Haase made changes -
          Attachment DERBY-4161-2.diff [ 12407016 ]
          Attachment cdevcsecureroles.html [ 12407017 ]
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Derby Info [Patch Available]
          Fix Version/s 10.5.1.2 [ 12313870 ]
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Resolution Fixed [ 1 ]
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kathey Marsden made changes -
          Fix Version/s 10.5.2.0 [ 12314116 ]
          Fix Version/s 10.5.1.2 [ 12313870 ]
          Gavin made changes -
          Workflow jira [ 12460838 ] Default workflow, editable Closed status [ 12799476 ]

            People

            • Assignee:
              Kim Haase
              Reporter:
              Tiago R. Espinha
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development