[jira] [Created] (RANGER-1063) Increase size of sort_order column of x_policy_item_user_perm and x_policy_item_group_perm table

["Pradeep Agrawal (JIRA)" <ji...@apache.org>]

Pradeep Agrawal created RANGER-1063:
---------------------------------------

             Summary: Increase size of sort_order column of x_policy_item_user_perm and x_policy_item_group_perm table
                 Key: RANGER-1063
                 URL: https://issues.apache.org/jira/browse/RANGER-1063
             Project: Ranger
          Issue Type: Bug
          Components: Ranger
    Affects Versions: 0.5.0, 0.6.0
            Reporter: Pradeep Agrawal
            Assignee: Pradeep Agrawal
             Fix For: 0.6.0


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)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)