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

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