From 5a5c1ff3ba2d3ede96c3ca35e5f18e406642833d Mon Sep 17 00:00:00 2001 From: "Kishore Reddy, Gujja (kg811t)" Date: Mon, 26 Mar 2018 14:25:08 -0400 Subject: [PATCH] Security fixes Issue-ID: PORTAL-136, PORTAL-155, PORTAL-210,PORTAL-217 Includes JUNITS and docker changes, music integration and security fixes Change-Id: Ib4ad7fbe28a3be9e159c4ab1f7818783c1ed5319 Signed-off-by: Kishore Reddy, Gujja (kg811t) --- .../PortalDDLMySql_2_1_Common.sql | 2 +- ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql | 30 +++++++++++----------- 2 files changed, 16 insertions(+), 16 deletions(-) diff --git a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql index fd3828a4..5c9e9b58 100644 --- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql +++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql @@ -11,7 +11,7 @@ -- ----------------------------------------------------------------------------------------------------------------- set foreign_key_checks=1; -create database portal; +create database portal_os; use portal; diff --git a/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql b/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql index 6461b13d..eb1564e2 100644 --- a/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql +++ b/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql @@ -127,27 +127,27 @@ insert into ep_app_role_function (id, app_id, role_id, function_cd, role_app_id) (4, 1, 1, 'menu|menu_logout|*', null), (5, 1, 16, 'url|login|*', null), (6, 1, 16, 'menu|menu_home|*', null), -(7, 1, 16, 'menu|menu_logout|*', null), +(7, 1, 16, 'menu|menu_logout|*', null), (8, 1, 950, 'url|edit_notification|*', null), (9, 1, 950, 'url|getAdminNotifications|*', null), (10,1, 950, 'url|saveNotification|*', null), -(11,1, 999,'url|userAppRoles|*','userAppRoles', null), +(11,1, 999,'url|userAppRoles|*', null), (12,1, 999, 'url|getAdminNotifications|*', null), -(13,1, 999,'url|userApps|*','User Apps'), +(13,1, 999,'url|userApps|*', null), (14,1, 1010, 'menu|menu_web_analytics|*', null), (15, 1, 2115, 'menu|menu_web_analytics|*', null), (16, 1 , 1, 'menu|menu_acc_admin|*' , null), -(17, 1 , 999 ,'menu|menu_acc_admin|*', null); -(18,1,999,'url|centralizedApps|*','Centralized Apps', null), -(19,1,999,'url|getAllWebAnalytics|*','Get All Web Analytics', null), -(20,1,999,'url|getFunctionalMenuRole|*','Get Functional Menu Role', null), -(21,1,999,'url|getNotificationAppRoles|*','Get Notification App Roles', null), -(22,1,999,'url|getUserAppsWebAnalytics|*','Get User Apps Web Analytics', null), -(23,1,999,'url|getUserJourneyAnalyticsReport|*','Get User Journey Report', null), -(24,1,999,'url|get_roles%2f%2a|*','getRolesOfApp', null), -(25,1,999,'url|get_role_functions%2f%2a|*','Get Role Functions', null), -(26,1,999,'url|notification_code|*','Notification Code', null), -(27,1,999,'url|role_function_list%2fsaveRoleFunction%2f%2a|*','Save Role Function', null), -(28,1,999,'url|syncRoles|*','SyncRoles', null); +(17, 1 , 999 ,'menu|menu_acc_admin|*', null), +(18,1,999,'url|centralizedApps|*', null), +(19,1,999,'url|getAllWebAnalytics|*', null), +(20,1,999,'url|getFunctionalMenuRole|*', null), +(21,1,999,'url|getNotificationAppRoles|*', null), +(22,1,999,'url|getUserAppsWebAnalytics|*', null), +(23,1,999,'url|getUserJourneyAnalyticsReport|*', null), +(24,1,999,'url|get_roles%2f%2a|*', null), +(25,1,999,'url|get_role_functions%2f%2a|*', null), +(26,1,999,'url|notification_code|*', null), +(27,1,999,'url|role_function_list%2fsaveRoleFunction%2f%2a|*', null), +(28,1,999,'url|syncRoles|*', null); commit; \ No newline at end of file -- 2.16.6