----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/74583/#review225738 -----------------------------------------------------------
security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql Lines 1806 (patched) <https://reviews.apache.org/r/74583/#comment314171> Add data_share_id to the unique-key constraint to enforce unique entries within a data share and allow the same resource to be included in another data share: UNIQUE KEY `x_gds_shared_resource_UK_resource_signature`(`data_share_id`, `resource_signature`) - Madhan Neethiraj On Sept. 12, 2023, 12:29 p.m., Prashant Satam wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/74583/ > ----------------------------------------------------------- > > (Updated Sept. 12, 2023, 12:29 p.m.) > > > Review request for ranger, Anand Nadar, Madhan Neethiraj, and Subhrat > Chaudhary. > > > Bugs: RANGER-4395 > https://issues.apache.org/jira/browse/RANGER-4395 > > > Repository: ranger > > > Description > ------- > > Currently we are not validating SharedResource Objects resources field if > they are already present in the database ,we need to add that validation > > > Diffs > ----- > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql > 4e0a9a746 > security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql > 13fd3724b > > > Diff: https://reviews.apache.org/r/74583/diff/2/ > > > Testing > ------- > > 1)Add SharedResource with duplicated resources will get validation Error > > > Thanks, > > Prashant Satam > >
