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

        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
        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
        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

          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