Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.0
    • Component/s: Security
    • Labels:
      None

      Description

      The SECURITY_PRINCIPAL table is not in normalized form. A number of users have complained about the principal tables not being normalized with the principal name in its own column, as well as the principal type in its own column. There are always needs to join to the user tables, and without normalized columns, it makes simple joins difficult for integrators.

      I have also seen requests for additional columns on the principal tables. Normally I recommend joining for these columns, or putting them in the user attributes. However I will consider doing so.

        Activity

        David Sean Taylor created issue -
        David Sean Taylor made changes -
        Field Original Value New Value
        Status Open [ 1 ] In Progress [ 3 ]
        David Sean Taylor made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        Hide
        David Sean Taylor added a comment -

        Will address this after 2.1 release

        Show
        David Sean Taylor added a comment - Will address this after 2.1 release
        Hide
        David Sean Taylor added a comment -

        Moving to post 2.1 release

        Show
        David Sean Taylor added a comment - Moving to post 2.1 release
        David Sean Taylor made changes -
        Fix Version/s 2.1-dev [ 12310686 ]
        Fix Version/s 2.2-dev [ 12312318 ]
        Affects Version/s 2.2-dev [ 12312318 ]
        Affects Version/s 2.1-dev [ 12310686 ]
        Hide
        David Sean Taylor added a comment -

        This was fixed in the 2.2 Security Refactoring branch

        Show
        David Sean Taylor added a comment - This was fixed in the 2.2 Security Refactoring branch
        David Sean Taylor made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Ate Douma made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            David Sean Taylor
            Reporter:
            David Sean Taylor
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:

              Development