/*==============================================================*/
/* DBMS name:      ORACLE Version 8i2 (8.1.6)                   */
/* Created on:     13/01/2005 09:32:11 a.m.                     */
/*==============================================================*/
define prefijo='VISIONI.'
set verify off

create public synonym VMLGRUPO FOR &prefijo.VMLGRUPO;
create public synonym VMLGRUPOUSUARIO FOR &prefijo.VMLGRUPOUSUARIO;
create public synonym VMLADJUNTOS FOR &prefijo.VMLADJUNTOS;
create public synonym VMLBANDEJA  FOR &prefijo.VMLBANDEJA;
create public synonym VMLCOPIAS   FOR &prefijo.VMLCOPIAS;
create public synonym VMLCORREO   FOR &prefijo.VMLCORREO;
create public synonym VMLUSUARIO  FOR &prefijo.VMLUSUARIO;
create public synonym VMLENVIOS   FOR &prefijo.VMLENVIOS;
create public synonym VMLIDENT    FOR &prefijo.VMLIDENT;

-- SYS debe dar este permiso
grant all on dbms_alert to public;

grant all on &prefijo.LICENCIA to public;
grant all on &prefijo.GEN_COMPANIA to public;
grant all on &prefijo.GEN_PARAMETRO to public;
grant all on &prefijo.GEN_SUCURSAL to public;
grant all on &prefijo.GEN_MONEDA to public;
grant all on &prefijo.GEN_IMPUESTO to public;
grant all on &prefijo.GEN_PERIODO_RANGO to public;
grant all on &prefijo.DBAMB to public;
grant all on &prefijo.CALCGEN to public;
grant all on &prefijo.GENPREFSVAL to public;

grant all on &prefijo.VMLGRUPO to public;
grant all on &prefijo.VMLGRUPOUSUARIO to public;

grant all on &prefijo.VMLADJUNTOS to public;
grant all on &prefijo.VMLBANDEJA  to public;
grant all on &prefijo.VMLCOPIAS   to public;
grant all on &prefijo.VMLCORREO   to public;
grant all on &prefijo.VMLUSUARIO  to public;
grant all on &prefijo.VMLENVIOS   to public;
grant all on &prefijo.VMLIDENT    to public;










grant connect, resource to marco;
grant connect, resource to candy;
grant connect, resource to marcosv;
grant connect, resource to gerardo;

insert into &prefijo.vmlusuario
   values ('VISIONI','VISIONI','ADM','S');

commit;
