Dejo la query para generar administradores en Nedaes, suplicio de aplicación para quien la use
Desde sql
-- ADD ADMIN USER TO NEDAES
insert into OIM_USR (CDIDENTI, CDCLAVE, DSNOM, DSDIR, NMTELE , CDPERFIL, OTPATH, CDHABIL , DSCONEXION, CDUSRUNIX, FECHAVIG, CDBLOQUEO, CDROL )
SELECT 'UMPA', 'LUMPA', DSNOM, DSDIR, NMTELE , CDPERFIL, OTPATH, CDHABIL , DSCONEXION, CDUSRUNIX, FECHAVIG, CDBLOQUEO, CDROL FROM OIM_USR WHERE cdidenti ='ADMIN';
insert into oim_clnm (CDIDENTI,CDHABIL,CDCLASNM,DSCLASNM) select 'UMPA',CDHABIL,CDCLASNM,DSCLASNM from oim_clnm where cdidenti ='ADMIN';
insert into oim_FUNC (CDIDENTI,CDFUNCI, SWALTAS, SWBAJAS,SWMODIFI, SWCONSUL) select 'UMPA',CDFUNCI, SWALTAS, SWBAJAS,SWMODIFI, SWCONSUL from oim_FUNC where cdidenti ='ADMIN';
commit;
-- USER PASS UMPA/LUMPA
DELETE FROM oim_clnm WHERE cdidenti ='UMPA';
DELETE FROM oim_FUNC WHERE cdidenti ='UMPA';
DELETE FROM OIM_USR WHERE cdidenti ='UMPA';
--DELETE USER UMPA