Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-4803

Add unique constraint on KIM permission namespace:name

    Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Database
    • Labels:
      None
    • Similar issues:
      KULRICE-6544PermissionService.isAuthorized, hasPermission, getPermissionAssignees, and getAuthorizedPermissions no longer needs to take permission details since permission namespace + name are now unique
      KULRICE-12100KIM Attributes are referenced by a non-unique identifier
      KULRICE-1490Add NAMESPACE_ID to KIM_PERMISSIONS_T and KIM_PERSON_ATTRIBUTES_T
      KULRICE-6784Add index and constraint on KREW_RULE_ATTR_T.NM
      KULRICE-54Add referential integrity support to the OJB-to-DDL generator so that constraints can be added
      KULRICE-13211Investigate attachmentTypeCode and KIM Permissions.
      KULRICE-5320create a migration script to make permission names/resp names unique
      KULRICE-2067Copying without changing the name (or other Unique Constraint fields) seems to allow for submission but actually throws a unique constraint
      KULRICE-13170KIM - Unable to add permission to existing role
      KULRICE-2578Add support for a group's namespaceCode to WorkgroupWorkflowEDLConfigComponent and WorkgroupRoleAttribute
    • Rice Module:
      KIM
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Review Completed

      Description

      In order to support upgrade scripts/xml injestion of KIM data we need a unique constraint on Permission namespace:name to identify permissions when we won't possibly know their pk sequence value. This will have some impact on client projects as currently the permission name is not a required field, so those would have to be populated if not already.

        Issue Links

          Activity

          Jeremy Hanson made changes -
          Field Original Value New Value
          Priority Major [ 3 ] Critical [ 2 ]
          Eric Westfall made changes -
          KTI Review Status Pending Review Review Completed
          Travis Schneeberger made changes -
          Link This issue is related to KULRICE-5320 [ KULRICE-5320 ]
          Travis Schneeberger made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Jessica Coltrin (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Shem Patterson (Inactive) made changes -
          Workflow custom [ 88212 ] Copy of custom for rice [ 212416 ]
          Shem Patterson (Inactive) made changes -
          Workflow Copy of custom for rice [ 212416 ] custom [ 222164 ]
          Shem Patterson (Inactive) made changes -
          Workflow custom [ 222164 ] Rice Workflow [ 231912 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Scott Gibson (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel