You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Dineshkumar Yadav <di...@outlook.com> on 2021/02/22 10:22:59 UTC
Re: Review Request 73174: RANGER-3172 : Patch to migrate old policy
to use new Policy Ref table
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/73174/
-----------------------------------------------------------
(Updated Feb. 22, 2021, 10:22 a.m.)
Review request for ranger, Gautam Borad, Kishor Gollapalliwar, Abhay Kulkarni, Mehul Parikh, Vishal Suvagia, and Velmurugan Periasamy.
Bugs: RANGER-3172
https://issues.apache.org/jira/browse/RANGER-3172
Repository: ranger
Description
-------
This Java Patch will perform below action.
Find out all the policies which had used old tables for policy creation (table like x_policy_item, x_policy_item_access, x_policy_item_user_perm, x_policy_item_group_perm, x_policy_resource, x_policy_resource_map).
Populate necessary new policy ref table.
Clean data from old tables.
Diffs
-----
security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql ad8c3ffae
security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql 759cdd0d5
security-admin/db/oracle/patches/050-create-index-for-resource-signature.sql 6974f7cf5
security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql 022ff82dd
security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql 69ccd8161
security-admin/db/sqlanywhere/patches/049-create-rms-schema.sql feb7b7f15
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql a2d7cb4ad
security-admin/src/main/java/org/apache/ranger/db/XXPolicyDao.java 49eff1e4e
security-admin/src/main/java/org/apache/ranger/db/XXPolicyItemAccessDao.java 671ed0edb
security-admin/src/main/java/org/apache/ranger/db/XXPolicyItemConditionDao.java 43e17db1a
security-admin/src/main/java/org/apache/ranger/db/XXPolicyItemDao.java 20ea7fa7a
security-admin/src/main/java/org/apache/ranger/db/XXPolicyItemDataMaskInfoDao.java 5cee710af
security-admin/src/main/java/org/apache/ranger/db/XXPolicyItemGroupPermDao.java 68cf4d020
security-admin/src/main/java/org/apache/ranger/db/XXPolicyItemRowFilterInfoDao.java 9c2edbc08
security-admin/src/main/java/org/apache/ranger/db/XXPolicyItemUserPermDao.java 63ef5cab6
security-admin/src/main/java/org/apache/ranger/db/XXPolicyResourceDao.java 6670a4efe
security-admin/src/main/java/org/apache/ranger/db/XXPolicyResourceMapDao.java 90123f57f
security-admin/src/main/java/org/apache/ranger/patch/PatchForMigratingOldRegimePolicyJson_J10046.java PRE-CREATION
security-admin/src/main/resources/META-INF/jpa_named_queries.xml 138145478
Diff: https://reviews.apache.org/r/73174/diff/3/
Testing
-------
Testing
1. created policy using which uses table like x_policy_item, x_policy_item_access, x_policy_item_user_perm, x_policy_item_group_perm, x_policy_resource, x_policy_resource_map.
2. After runnig this patch all the new Ref policy tables get populated and run clean up for previously used old ref table.
Thanks,
Dineshkumar Yadav