summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_5_to_2_6_Common.sql
blob: 5c8069817c01aff8216f7fe13b9c2e56fe5053f3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
use ecomp_sdk;

SET FOREIGN_KEY_CHECKS=0;

INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/add_formfield_tab_data/*','menu_reports');
INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/save_formfield_tab_data/*','menu_reports');
INSERT INTO fn_restricted_url (restricted_url, function_cd) VALUES ('report/wizard/retrieve_form_tab_wise_data/*/delete','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 VALUES('serviceModels','serviceModels ');
INSERT INTO fn_restricted_url VALUES('serviceModels','menu_admin');
INSERT INTO fn_restricted_url VALUES('report/wizard/list_columns','menu_reports');
INSERT INTO fn_restricted_url VALUES('report/wizard/list_formfields','menu_reports');
INSERT INTO fn_restricted_url VALUES('report/wizard/retrieve_data/*','menu_reports');
INSERT INTO fn_restricted_url VALUES('report/wizard/retrieve_col_tab_wise_data/*','menu_reports');
INSERT INTO fn_restricted_url VALUES('welcome','menu_reports');
INSERT INTO fn_restricted_url VALUES('report/security/addReportUser','menu_reports');
INSERT INTO fn_restricted_url VALUES('report/security/addReportRole','menu_reports');
INSERT INTO fn_restricted_url VALUES('report/security/*','menu_reports');
INSERT INTO fn_restricted_url VALUES('report/wizard/get_report_log/*','menu_reports');

commit;