[ranger] branch RANGER-3923 updated: RANGER-4395: avoid duplicate resource entries in a datashare

[madhan]

This is an automated email from the ASF dual-hosted git repository.

madhan pushed a commit to branch RANGER-3923
in repository https://gitbox.apache.org/repos/asf/ranger.git


The following commit(s) were added to refs/heads/RANGER-3923 by this push:
     new 0371f6663 RANGER-4395: avoid duplicate resource entries in a datashare
0371f6663 is described below

commit 0371f66639d804fb7c15a0816c37a8aaf0cce0c8
Author: Prashant Satam <prashant.sa...@privacera.com>
AuthorDate: Wed Sep 13 13:01:33 2023 +0530

    RANGER-4395: avoid duplicate resource entries in a datashare
    
    Signed-off-by: Madhan Neethiraj <mad...@apache.org>
---
 security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql       | 1 +
 security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql | 1 +
 2 files changed, 2 insertions(+)

diff --git a/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 
b/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
old mode 100644
new mode 100755
index 4e0a9a746..424f38d9e
--- a/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
+++ b/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
@@ -1803,6 +1803,7 @@ CREATE TABLE `x_gds_shared_resource`(
   , `additional_info`      TEXT         NULL     DEFAULT NULL
   , PRIMARY KEY(`id`)
   , UNIQUE KEY `x_gds_shared_resource_UK_name`(`data_share_id`, `name`)
+  , UNIQUE KEY `x_gds_shared_resource_UK_resource_signature`(`data_share_id`, 
`resource_signature`)
   , CONSTRAINT `x_gds_shared_resource_FK_added_by_id`   FOREIGN 
KEY(`added_by_id`)   REFERENCES `x_portal_user`(`id`)
   , CONSTRAINT `x_gds_shared_resource_FK_upd_by_id`     FOREIGN 
KEY(`upd_by_id`)     REFERENCES `x_portal_user`(`id`)
   , CONSTRAINT `x_gds_shared_resource_FK_data_share_id` FOREIGN 
KEY(`data_share_id`) REFERENCES `x_gds_data_share`(`id`)
diff --git 
a/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql 
b/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
old mode 100644
new mode 100755
index 13fd3724b..5ffa23f33
--- a/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
+++ b/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
@@ -1795,6 +1795,7 @@ CREATE TABLE x_gds_shared_resource(
   , additional_info      TEXT         NULL     DEFAULT NULL
   , PRIMARY KEY(id)
   , CONSTRAINT x_gds_shared_resource_UK_name UNIQUE(data_share_id, name)
+  , CONSTRAINT x_gds_shared_resource_UK_resource_signature 
UNIQUE(data_share_id, resource_signature)
   , CONSTRAINT x_gds_shared_resource_FK_added_by_id   FOREIGN KEY(added_by_id) 
REFERENCES x_portal_user(id)
   , CONSTRAINT x_gds_shared_resource_FK_upd_by_id     FOREIGN KEY(upd_by_id)   
REFERENCES x_portal_user(id)
   , CONSTRAINT x_gds_shared_resource_FK_data_share_id FOREIGN 
KEY(data_share_id) REFERENCES x_gds_data_share(id)