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

SQL Roles - Clarify documentation regarding the SET ROLE

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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?

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: