summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts
diff options
context:
space:
mode:
authorWelch, Lorraine (lb2391) <lb2391@att.com>2019-05-23 16:40:04 -0400
committerWelch, Lorraine (lb2391) <lb2391@att.com>2019-05-23 16:40:04 -0400
commite2aaf7d7d12d5a05d25cbe4439bc13cec2570813 (patch)
tree921f79ee8b81f0f1a4093c09174fcfd98c338e2d /ecomp-sdk/epsdk-app-common/db-scripts
parent68eabf669e4c83bd669286900e8a6f77e4009f29 (diff)
Added fn_restricted_url entries
Issue-ID: PORTAL-521 Signed-off-by: Welch, Lorraine (lb2391) <lb2391@att.com> Change-Id: I4fcd12b888f9b813829ae8343da291c64452b29f
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts')
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_2_5_Common.sql91
1 files changed, 61 insertions, 30 deletions
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_2_5_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_2_5_Common.sql
index 50221612..c158719b 100644
--- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_2_5_Common.sql
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_2_5_Common.sql
@@ -135,35 +135,66 @@ INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('tab3.htm','
INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('tab4.htm','menu_tab');
INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('raptor.htm','view_reports');
INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('raptor_blob_extract.htm','view_reports');
-INSERT INTO fn_restricted_url VALUES('admin','menu_admin');
-INSERT INTO fn_restricted_url VALUES('get_role','menu_admin');
-INSERT INTO fn_restricted_url VALUES('get_role_functions','menu_admin');
-INSERT INTO fn_restricted_url VALUES('role_list/*','menu_admin');
-INSERT INTO fn_restricted_url VALUES('role_function_list/*','menu_admin');
-INSERT INTO fn_restricted_url VALUES('addRole','menu_admin');
-INSERT INTO fn_restricted_url VALUES('addRoleFunction','menu_admin');
-INSERT INTO fn_restricted_url VALUES('removeRole','menu_admin');
-INSERT INTO fn_restricted_url VALUES('removeRoleFunction','menu_admin');
-INSERT INTO fn_restricted_url VALUES('profile/*','menu_admin');
-INSERT INTO fn_restricted_url VALUES('samplePage','menu_sample');
-INSERT INTO fn_restricted_url VALUES('workflows','menu_admin');
-INSERT INTO fn_restricted_url VALUES('workflows/list','menu_admin');
-INSERT INTO fn_restricted_url VALUES('workflows/addWorkflow','menu_admin');
-INSERT INTO fn_restricted_url VALUES('workflows/saveCronJob','menu_admin');
-INSERT INTO fn_restricted_url VALUES('workflows/editWorkflow','menu_admin');
-INSERT INTO fn_restricted_url VALUES('workflows/removeWorkflow','menu_admin');
-INSERT INTO fn_restricted_url VALUES('workflows/removeAllWorkflows','menu_admin');
-INSERT INTO fn_restricted_url VALUES('role/saveRole.htm','menu_admin');
-INSERT INTO fn_restricted_url VALUES('post_search/process','menu_admin');
-INSERT INTO fn_restricted_url VALUES('post_search/search','menu_admin');
-INSERT INTO fn_restricted_url VALUES('post_search/search','menu_profile');
-INSERT INTO fn_restricted_url VALUES('report/wizard/retrieve_def_tab_wise_data/*','menu_reports');
-INSERT INTO fn_restricted_url VALUES('report/wizard/retrieve_form_tab_wise_data/*','menu_reports');
-INSERT INTO fn_restricted_url VALUES('report/wizard/retrieve_sql_tab_wise_data/*','menu_reports');
-INSERT INTO fn_restricted_url VALUES('report/wizard/security/*','menu_reports');
-INSERT INTO fn_restricted_url VALUES('report/wizard/copy_report/*','menu_reports');
-INSERT INTO fn_restricted_url VALUES('report/wizard/save_def_tab_data/*','menu_reports');
-INSERT INTO fn_restricted_url VALUES('report/wizard/retrieve_data/true','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('admin','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('get_role','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('get_role_functions','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('role_list/*','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('role_function_list/*','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('addRole','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('addRoleFunction','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('removeRole','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('removeRoleFunction','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('profile/*','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('samplePage','menu_sample');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('workflows','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('workflows/list','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('workflows/addWorkflow','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('workflows/saveCronJob','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('workflows/editWorkflow','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('workflows/removeWorkflow','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('workflows/removeAllWorkflows','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('role/saveRole.htm','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('post_search/process','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('post_search/search','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('post_search/search','menu_profile');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_def_tab_wise_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_form_tab_wise_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_sql_tab_wise_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/security/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/copy_report/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/save_def_tab_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_data/true','menu_reports');
+
+-- new for Dublin
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('novamap_controller.htm','menu_map');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('/report*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('/report/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('/report/wizard/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('/report/wizard/retrieve_col_tab_wise_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('/report/wizard/retrieve_sql_tab_wise_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/security/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/security/addReportRole','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/security/addReportUser','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/drill_down_param/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/get_report_log/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/getDrillDownReportList','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/list_child_report_col/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/list_child_report_ff/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/list_columns','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/list_formfields','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_col_tab_wise_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_data/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_form_tab_wise_data/*/*','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieveTotalForTheColList','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report_blob_extract.htm','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report_email_attachment.htm','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report_search.htm','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report2.htm','menu_reports');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('sample_heat_map.htm','menu_tab');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('sample_heat_map_no_header.htm','menu_tab');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('serviceModels','menu_admin');
+INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('welcome','menu_reports');
-- fn_role
Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (16,'Standard User','Y',5);
@@ -2878,4 +2909,4 @@ INSERT INTO demo_util_chart (TRAFFIC_DATE,UTIL_PERC ) VALUES (str_to_date('2016-
INSERT INTO demo_util_chart (TRAFFIC_DATE,UTIL_PERC ) VALUES (str_to_date('2016-03-07','%Y-%m-%d'),61.86667);
INSERT INTO demo_util_chart (TRAFFIC_DATE,UTIL_PERC ) VALUES (str_to_date('2016-03-08','%Y-%m-%d'),62.00000);
-commit; \ No newline at end of file
+commit;