eosrolemenu_data.sql
来自「软件维护单管理系统, 软件维护单管理系统」· SQL 代码 · 共 249 行
SQL
249 行
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_003_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_003_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_002_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_002_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_002_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FBFILE_Manager1');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_System_BNDict');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_ChangePass');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_SetFuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_Menu_Menu');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_Orgjigou');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_BizOrg');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_ManageRole');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_DataAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_Busi_Busi');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_OperatorMain');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_002_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_002_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_002_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_003_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_003_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_003_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolea', 'WF5_003_004');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'roleb', 'WF5_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'roleb', 'WF5_002_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'roleb', 'WF5_002_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'roleb', 'WF5_002_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolec', 'WF5_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolec', 'WF5_002_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolec', 'WF5_002_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'rolec', 'WF5_002_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'softwar_main_query');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', '11');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FBFILE_Manager');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_FuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_EDIT');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_Org');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'FDFRAME_Authority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'software_main');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_003_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_003_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_003_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_002_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_002_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_002_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_System_BNDict');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_ChangePass');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_SetFuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_Menu_Menu');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_Orgjigou');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_BizOrg');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_ManageRole');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_DataAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_Busi_Busi');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_OperatorMain');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'softwar_main_query');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', '11');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_FuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_EDIT');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_Org');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'FDFRAME_Authority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'software_main');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_003_004');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_003_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_003_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_003_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_002_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_002_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_002_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_System_BNDict');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_ChangePass');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_SetFuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_Menu_Menu');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_Orgjigou');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_BizOrg');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_ManageRole');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_DataAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_Busi_Busi');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_OperatorMain');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'softwar_main_query');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', '11');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'WF5_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_FuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_EDIT');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_Org');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'FDFRAME_Authority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'1', 'software_main');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_003_004');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_003_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_003_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_003_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_002_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_002_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_002_001');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_System_BNDict');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_ChangePass');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_SetFuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_Menu_Menu');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_Orgjigou');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_BizOrg');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_ManageRole');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_DataAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_Busi_Busi');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_OperatorMain');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'softwar_main_query');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', '11');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_003');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'WF5_002');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_FuncAuthority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_EDIT');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_Org');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'FDFRAME_Authority');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'2', 'software_main');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'3', 'WF5_003_004');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_003_004');
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES (
'eosadmin', 'WF5_003_003');
commit;
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?