delete from CMSCLAVESEMP
delete from CXCDETDISTRIBUCION
delete from CXCDISTRIBUCION
DELETE FROM INVTMP
DELETE PLADETPASIVO

DELETE FROM GENIMPBARRAS

define role="SISTEMAS"
define owner="LANCOESV"
set verify off

CREATE PUBLIC SYNONYM CMSCLAVESEMP FOR &OWNER..CMSCLAVESEMP;                                                                
CREATE PUBLIC SYNONYM CXCDETDISTRIBUCION FOR &OWNER..CXCDETDISTRIBUCION;                                                                    
CREATE PUBLIC SYNONYM CXCDISTRIBUCION FOR &OWNER..CXCDISTRIBUCION;                                                              
CREATE PUBLIC SYNONYM PLADETPASIVO FOR &OWNER..PLADETPASIVO;                                                                        


GRANT ALL ON CMSCLAVESEMP TO &ROLE;                                                                                           
GRANT ALL ON CXCDETDISTRIBUCION TO &ROLE;                                                                                             
GRANT ALL ON CXCDISTRIBUCION TO &ROLE;                                                                                          
GRANT ALL ON PLADETPASIVO TO &ROLE;    