MAXIMO给管理员授权所有组

xiangzhao

发现MAXIMO权限组这个地方涉及的超级麻烦，就写了这个东东！

delete from GRPREASSIGNAUTH t where t.userid = 'MAXADMIN';
insert into GRPREASSIGNAUTH select GRPREASSIGNAUTHseq.Nextval,'MAXADMIN',t.groupname,null from maxgroup t ;
delete from GROUPUSER t where t.userid = 'MAXADMIN';
insert into GROUPUSER select GROUPUSERseq.Nextval,'MAXADMIN',t.GROUPNAME,NULL FROM GRPREASSIGNAUTH t WHERE t.userid = 'MAXADMIN';
commit;