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

          No work has yet been logged on this issue.

            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