INSERT INTO SECURITYUSERROLE (USER_, SECURITYROLE, ASSIGNMENTMODE, ASSIGNMENTSTATUS, VALIDFROM, VALIDTO, VALIDFROMTZID, VALIDTOTZID)
SELECT '<to user>',SECURITYROLE, ASSIGNMENTMODE,
ASSIGNMENTSTATUS,VALIDFROM, VALIDTO, VALIDFROMTZID, VALIDTOTZID FROM SECURITYUSERROLE
WHERE USER_ in ('<from user>') ;
INSERT INTO omUserRoleOrganization (USER_, OMHIERARCHYTYPE, OMINTERNALORGANIZATION, SECURITYROLE, SECURITYROLEASSIGNMENTRULE)
SELECT '<to user>',OMHIERARCHYTYPE, OMINTERNALORGANIZATION,
SECURITYROLE,SECURITYROLEASSIGNMENTRULE FROM omUserRoleOrganization
WHERE USER_ in ('<from user>');
INSERT INTO SYSLASTVALUE (USERID, RECORDTYPE, ELEMENTNAME, DESIGNNAME, ISKERNEL, COMPANY,VALUE,DOCUMENT)
SELECT '<to user>',RECORDTYPE, ELEMENTNAME,
DESIGNNAME,ISKERNEL,COMPANY,VALUE,DOCUMENT FROM SYSLASTVALUE
WHERE USERID in ('<from user>');
No comments:
Post a Comment