HEGII.ss.mes.web/wwwroot/sqlupdate/004增加ADMIN的WEB管理权限TP_MST_USERRIGHT.sql

DELETE TP_MST_USERRIGHT WHERE USERID= 723 AND FUNCTIONCODE LIKE '80%';
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '80', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '8050', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '805001', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '805002', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '805003', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '805004', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '8070', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '807001', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '807002', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '807003', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '807004', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '8090', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '809001', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '809002', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '809003', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '809004', '1');
INSERT INTO TP_MST_USERRIGHT(USERID, FUNCTIONCODE, CREATEUSERID) VALUES ('723', '809005', '1');