----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/62074/ -----------------------------------------------------------
Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Pradeep Agrawal, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy. Bugs: RANGER-1765 https://issues.apache.org/jira/browse/RANGER-1765 Repository: ranger Description ------- Currently, concurrent request to create a group or create group-users mapping is causing duplicate entries of the same group in x_group table. This need to be restricted in DB tables by creating relevant constraint on the table. Diffs ----- security-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql PRE-CREATION security-admin/db/oracle/patches/028-add-unique-constraint-on-table-x_group.sql PRE-CREATION security-admin/db/postgres/patches/028-add-unique-constraint-on-table-x_group.sql PRE-CREATION security-admin/db/sqlanywhere/patches/028-add-unique-constraint-on-table-x_group.sql PRE-CREATION security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql 68d3a05 security-admin/db/sqlserver/patches/028-add-unique-constraint-on-table-x_group.sql PRE-CREATION Diff: https://reviews.apache.org/r/62074/diff/1/ Testing ------- 1. Tested Ranger Admin, Usersync, Ranger KMS with all database flavour. Thanks, bhavik patel