[ 
https://issues.apache.org/jira/browse/RANGER-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pradeep Agrawal updated RANGER-1063:
------------------------------------
    Attachment: RANGER-1063-1.patch

> 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
>
>         Attachments: RANGER-1063-1.patch
>
>
> 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)

Reply via email to