[ranger] branch ranger-2.4 updated: RANGER-4241: Fix sql patch 65 syntax issue for oracle db

[pradeep]

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

pradeep pushed a commit to branch ranger-2.4
in repository https://gitbox.apache.org/repos/asf/ranger.git


The following commit(s) were added to refs/heads/ranger-2.4 by this push:
     new 613c62c9c RANGER-4241: Fix sql patch 65 syntax issue for oracle db
613c62c9c is described below

commit 613c62c9cc32a00074600f9739153230cf8a25eb
Author: Pradeep Agrawal <prad...@apache.org>
AuthorDate: Tue May 16 19:53:31 2023 +0530

    RANGER-4241: Fix sql patch 65 syntax issue for oracle db
---
 .../065-add-uk-on-x_rms_service_resource-resource_signature.sql        | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git 
a/security-admin/db/oracle/patches/065-add-uk-on-x_rms_service_resource-resource_signature.sql
 
b/security-admin/db/oracle/patches/065-add-uk-on-x_rms_service_resource-resource_signature.sql
index f91dfef06..f19630ca8 100644
--- 
a/security-admin/db/oracle/patches/065-add-uk-on-x_rms_service_resource-resource_signature.sql
+++ 
b/security-admin/db/oracle/patches/065-add-uk-on-x_rms_service_resource-resource_signature.sql
@@ -12,7 +12,6 @@
 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
--- sync_source_info CLOB NOT NULL,
 
 DECLARE
     v_index_exists number:=0;
@@ -30,7 +29,7 @@ BEGIN
     commit;
     SELECT COUNT(*) INTO v_index_exists FROM USER_INDEXES WHERE INDEX_NAME = 
upper('x_rms_svc_res_IDX_res_sgn') AND TABLE_NAME= 
upper('x_rms_service_resource');
     IF (v_index_exists > 0) THEN
-        EXECUTE IMMEDIATE 'DROP INDEX x_rms_svc_res_IDX_res_sgn ON 
x_rms_service_resource(resource_signature)';
+        EXECUTE IMMEDIATE 'DROP INDEX x_rms_svc_res_IDX_res_sgn';
         commit;
     END IF;