Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-1063

Increase size of sort_order column of x_policy_item_user_perm and x_policy_item_group_perm table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.5.0, 0.6.0
    • Fix Version/s: 0.6.0
    • Component/s: Ranger
    • Labels:
      None

      Description

      Problem Statement : Currently data type of sort_order column is tinyint which can accept maximum 128 unsigned number; if any policy item is having more than 128 users then data truncation error might be generated at DB end and application will not be able to insert entry of any more user for specific policy item.

      Proposed Solution : Change data type of sort_order column of 'x_policy_item_user_perm' and 'x_policy_item_group_perm' table from tinyint to integer(4 byte)

        Attachments

        1. RANGER-1063-1.patch
          11 kB
          Pradeep Agrawal

          Issue Links

            Activity

              People

              • Assignee:
                pradeep.agrawal Pradeep Agrawal
                Reporter:
                pradeep.agrawal Pradeep Agrawal
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: