GRANT EXECUTE ON PROCEDURE SALDO_DOC_CXPAGAR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_EN_CAJA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_EN_EFECTIVO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_FINAL_CAJA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_FINAL_CUENTA_BANCO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INICIAL_INVENTARIO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INICIAL_PROVEEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INICIAL_TOTAL_INV        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INVENTARIO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_LOTE                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_LOTE_FECHA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_PROVEEDOR                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCERO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCERO_MES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TOTAL_INVENTARIO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDOS_ARTICULO_CUENTA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDOS_FACTURA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALIDAS_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SELECCIONE_LOTE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGIERE_METAS_VENTAS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGIERE_PRECIO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_EXISTENCIA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_BANCO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_CAJA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_CUENTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_EFECTIVO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TARIFAS_ENSAMBLE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_DOC_COMPRA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_DOC_IMPORT               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_DOC_VENTAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_PAGOS_TERCERO_ANO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASCUENTAS_SIN_CONTABILIDAD   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_ITEM              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22761                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASFERENCIAS_SIN_CONTABILIDAD TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_REMESA                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASLACAJAS_SIN_CONTABILIDAD   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMO_COMPROMISO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMO_COSTO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMO_EVENTO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE UNIDADES                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE USUARIOS_MENSAJE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_TERCERO_DESDE_HASTA_N TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CENTRO_DESDE_HASTA_N  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE UTILIDAD_VENTAS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDA_CUENTAS_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_ARTICULO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_BONO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_CUENTA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_CUENTA_C                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_ESTRUCTURA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_EXISTENCIA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_NIVEL                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_PADRE                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALOR_INICIAL_INVENTARIO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENCIDO_CLIENTE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ANUALES_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ANUALES_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ANUALES_VENDEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_ANO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_CLIENTE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_VENDEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CADENA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE_ANO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE_MES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE_VENDEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_POR_HORA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_POR_HORA_ARTICULO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_VENDEDOR                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_VENDEDOR_ANO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_VENDEDOR_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VERIFIQUE_CUENTA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_DIFERENCIAS_CONTEO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRA_CONTABIL_DOCUMENTOS      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_LOTES_FECHA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_PRIMA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_CESANTIA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_APORTES_NOMINA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_ARTICULOS_MOVIL       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ARTICULO_MOVIL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTES_MOVIL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRA_RECIBO_FACTURA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_ITEM_FACTURA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTREGA_ITEM                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTREGA_FIN                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TERCEROS_CREADOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_INVENTARIO_FECHA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_NIIF_PROM_Y_ULT_UNIDAD   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_22                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_24                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_26                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_23                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CENTRO_TERCERO_MES TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COPIA_SALDOS_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CENTRO_TERCERO_MES     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRA_PROVISION             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_CONSOLIDADO_FECHA      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALIDAS_ANO_ANTERIOR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDEN_SUGERIDA_TOTAL           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VARIACION_COSTOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_MANIFIESTO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10068                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_TAXONOMIA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_TERCEROS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_EMPLEADOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_MOVTERCEROS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_FACTURACIONPAPEL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_FACTURACIONPOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODUCCION_NIIF       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCHEQ_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DESENSAMBLE_NIIF      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIQ_PARQUEADERO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PARQUEADERO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODDEV_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODENT_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODSAL_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECIBO_RECAUDO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMICLIE_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCOMP_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMIPROV              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_TIEMPOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMIPROV_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRCL_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBCL_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PERIODO_NOM_FECHAF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_APLICACL_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRPR_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_CLIENTE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_CLIENTE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_VENDEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBPR_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_APLICAPR_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RECICAJA_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_EGRESO_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_33                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_34                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_COSTO_VENTAS_CONTADO  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_PEND_ALISTA_FACT          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DET_EMBALAJE_FACT         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_EMBALAJE_FACT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_TRANSMIT              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_CONSUMO_VENTAS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_FACTELECTRONICA21       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PARTE_CADENA_COMAS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIUDAD_TERCERO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_TERCEROS_CREADOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_FACTURAS_USUARIO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_FACTURAS_DETALLE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRUNCAR_TELEFONO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCS_INVENTARIO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_SISMED                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ACTIVOS                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_36                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_310                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LISTA_PRECIOS_CON_ESCALA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_COTIZA_WEB               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTOR_UNIDAD_CANT_EXCEP       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_EN_VENTAS_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGERIDO_BODEGA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VACACIONES_NOMINA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLVER_ITEM_NEGATIVOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DETERIORO_CARTERA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_INICIAL_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESTAMOS_NOMINA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CENTRO_MES_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIBRO_DIARIO_CUENTA_N          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CUENTA_MES_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BASE_APORTES                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_MES_NIIF               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_IVA_COMPRA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALARIO_PROMEDIO_DETALLE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ES_AFECTABLE_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PENDIENTES_EVENTO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CON_TERCEROS_MES_N     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_ANUAL_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CUENTA_DE_HASTA_N  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILICE_EQUIVALENCIA_NIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_PRUEBA_ACUMULADO_NIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_CENTROS_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRECIOS_TODOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRECIOS_SISMED             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_SISMED             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCUMENTOS_SERIAL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SERIALES_ITEM_DOCUMENTO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_UNIDAD_BOD         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_AGENCIA_FP              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_CAJAS_FECHA     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CON_TERCEROS_ACUM      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_APORTE                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CIERRE_COMP_INT       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_GASTOS_IMPORTACION   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ARTICULOS_PROVEEDORI       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FALTANTES_PROVEEDORI       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_IMP           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_31                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_RETENCION_LABORAL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP_INT          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DETERIORO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_FACTURA_WEB              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAR_EVENTO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CLIENTES_BIT               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIO_TARIFA_IVA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIO_PRECIOS_IVA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_VENDEDOR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_PUNTO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_PUNTO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_FECHA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_MOVIMIENTO_ARTICULO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTES_MOVIL_OFFLINE    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLCLI_SIN_CONTABILIDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENSAMBLES_SIN_CONTABILIDAD_NIIFTO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTRADAS_SIN_CONTABILIDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_SIN_CONTABILIDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALIDAS_SIN_CONTABILIDAD_NIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASLADOS_SIN_CONTABILDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_BIT                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTASDET_BIT              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CARTERA_CLIENTES_OFFLINE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_SKU_BIT                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_RUTAS_BIT                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ORDENINT                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILIZA_PENDIENTE_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_ARTICULO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_FECHA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_INVENTARIO_AGOTADOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_GRUPO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_COMPRAS_GRUPO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_COMPRAS_PROVEEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_CARTERA_CLIENTES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_MOVIMIENTO_CLIENTES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_CXPAGAR                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_MOVIMIENTO_PROVEEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_RESUMEN_SALDOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_RESUMEN_CAJA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_RESUMEN_BANCOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_CXPAGAR               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_CARTERA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_CAJA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_BANCOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DETCART              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDENE_TARIFAS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRESTAMOS_NOMINA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDADO_PROVISIONES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_COMPRAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAR_PEDIDOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTE_WEB               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP_INTN         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CIUDADES_MOVIL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURA_ALQUILER_Y_TRANSPORTE  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDENES_COMPRA_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INF_CERTIFICADOS_RETENCION     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_RIMAR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_CAJA_DETALLE_F          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_COSTOS_CONTADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_VENDEDOR_RIMAR      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_FECHAS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALOR_INVENTARIO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TOTAL_BANCOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CARTERA_TOTAL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_GERENCIAL_RIMAR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGERIDO_PROVEEDOR             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_SUGERIDO_PROVEEDOR         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CERTIFICADOS_RETENCION_NIIF    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_APORTE_NOV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIFERENCIAS_FACTURAS_BD        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REDONDEE_AP                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ARTICULO_MES_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_FACTELECTRONICA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRODUCCION_PENDIENTE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GENERE_ORDEN_INV_PLAN          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTRADAS_GRUPO_MES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIF                            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTOS_PRODUCCION              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_COSTO_PROVC          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTES_POSMOVIL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_SUBGRUPOS_POSMOVIL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ARTICULOS_POSMOVIL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETFACTURA_POSMIVIL       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_FACTURA_POSMOVIL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_FACTURAS_VEND_POSMOVIL    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EGRESOS_DEVCONTADO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIERRE_ABONOS_EFECTIVO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_COSTO_ENTRADAS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DETALLE_RETENCION          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_UTILIDAD_VENTAS_EX         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CRUCES_COMPRAS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_FACTURAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_FACTPROFV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCAR_CLIENTES_MOVIL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ARTICULO_MOVILV2          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCAR_ARTICULOS_MOVIL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACCESO_USUARIO_MOVIL           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTPROFV             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1001_10                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10079                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_POR_EMPACAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TIPO_EMBALAJE_ALISTAMIENTO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETALLE_FACTURA_EMPAQUE   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AHORRO_TOTAL                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRAR_FACTURA_WEB             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_FACTURAS_VEND             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_NUMERO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22762_N                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22762                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_COSTO_COMPRAS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VER_ARTICULOS_FACTWEB          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLVER_FACTURA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RUTERO_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_EMPLEADO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_CTAART       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_CTAART_N     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_TIVA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_TIVA_N       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PROMEDIO_SALIDAS_ARTICULOI     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDEN_SUGERIDA_TOTALI          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PEDIDOS_X_CLIENTE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REVISA_PRECIOS_ARTICULO_COMPRASTO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_CTAART_N      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_TIVA_N        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ERRORINT_N                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_EQUIVALENCIA_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PROGPAGO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_ARTICULO_FAC            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARCHIVO_BANCO_CXP              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETALLE_FACTURA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_VENTAS_TIVA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_POR_ALISTAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETALLE_FACTURA_ALISTA    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_VENTAS_CONTADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_COSTOS_CONTADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTOS_PRODUCCION_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_CUENTAS_NO_TERCERO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PUNTOS_DOCUMENTO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_PUNTOS_TX1             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_MOVCAJA_DOCCAJA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ORDENSERV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ORDENSER             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_FECHA_COMPROBANTE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CREA_ARTICULOS_BD              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_NITA TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_COSTOS_COMPRA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_PROD          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTA_MAL_AFECTABLE_N         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_SALIDA_DECIMALES      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECIBOS_TOTALES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_MOVCXPAGAR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COSTOSPROD                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_REMISIONES_ENTREGA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPTOS_VENTAS_RESUMEN          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMBRE_ALFANUMERICO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_HISTORIAL_CHAT          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PROVEEDORES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_TIVA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PROVEEDORES_CONSULTA    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_CATALOGO_ARTICULOS      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_BUSQUEDA_ARTICULOS      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_CTAART        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_BUSCAFAC                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INACTIVAR_ACTUALIZACION_BALNIIFTO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTIVAR_ACTUALIZACION_BALNIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_CTARTTO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_TIVA TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PEDIDOSVSFACTURAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_NA   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_NT   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REMISIONES_SIN_CONTABILIDAD    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_FALTANTESPED            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_ARTICULOS_CREADOS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_CLIENTES_TIEMPO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AGREGA_COSTOS_VENTAS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_HISTORIAL_RECIBOS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PRO_CONTACTOS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_TERCERO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESENTACIONES_APP             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_APP                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESENTACIONES_OK              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INICIA_DESCARGA_PRESENTACIONES TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_OK                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INICIA_DESCARGA_CLIENTES       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIOS_APP                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_APP                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLISUCURSALES_APP              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_SUCURSAL                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_INVENTARIO_FACTURABLE    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDA_BARRAS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_OK                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INICIA_DESCARGA_EXISTENCIAS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_MINIMO_PROV        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AJUSTES_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_ENTRADAS_CONSUMO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_LNR                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_CAMBSAL                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARTICULOS_MILISTAPP            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_MES_EMPLEADO               TO PUBLIC;

GRANT USAGE ON SEQUENCE RDB$SECURITY_CLASS             TO PUBLIC;
GRANT USAGE ON SEQUENCE SQL$DEFAULT                    TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$PROCEDURES                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$EXCEPTIONS                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$CONSTRAINT_NAME            TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$FIELD_NAME                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$INDEX_NAME                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$TRIGGER_NAME               TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$BACKUP_HISTORY             TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$FUNCTIONS                  TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$GENERATOR_NAME             TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORTE_ERRORES_ID         TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AJUSTECIE                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AJUSTEINF                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AJUSTEINV                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ALERTAS                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ANTICIPO_PROVEEDOR          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ANTICLIE                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_APLICACLIE                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_APLICAPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ARTICULO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AUDITORIA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_BANCO                       TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_BONOPAGO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBCOSTO                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBIODOC                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMPANA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMSITUA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CARGOGASTO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CHEQUES                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CIERANUAL                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CIERTERC                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COMPROBA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COMPROMISO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONCILIAB                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONFIRMDEPOS                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONS                        TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSIGNA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSIGNATAR                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSNO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSNOPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSOLIDA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSOLIDADO                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSUMOS                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONTABILIZA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COTIPROV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COTIZACI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CUENTA_BANCO                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DESENSAMBLE                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEVOLCLI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEVOLPROV                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEVOLUCION_CHEQUES          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DISFVACAC                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DOCPAGOCAJA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EGRESOS                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENSAMBLE                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENTRADA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENTRSALEMPL                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENVIO                       TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ERRORES                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EVENTO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTCOMP                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTCONT                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTPER                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTURA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FORMDATOS                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_HORAEMPL                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERBANCO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCAJA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCARTERA                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCMP                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCOMPRA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCXPAGAR                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERFAZ_INVENTARIO         TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERVTA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_LOTE                        TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MENSAJE                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVARTI                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVBANCO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVCAJA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVCLI                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVPROV                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVSALEMPL                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMICOMI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMINA                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMINA_PROV                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMI_NOVEDADES              TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTACRCLI                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTACRPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTADBCLI                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTADBPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTADOC                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTASCLIENTES               TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTAS_CREDITO_BANCO         TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTAS_DEBITO_BANCO          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDEMBAR                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENCOMP                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENMCIA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENPROD                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PAGONOMI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PAGO_CLIENTE                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PAGO_PROVEEDOR              TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PEDIDO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PENDIENTE                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PGAPORT                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PLANPROD                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PLANTILLA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRESTAMOS                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRODDEV                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRODENT                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRODSAL                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PUNTOS                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PUNTOSVEND                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECICAJA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECIPROV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REDPTOSV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REMICLIE                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REMIPROV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REPLARTICULO                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REPUTILIDAD                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RESERVA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RETENCIONES                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RETIROS                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REVPRECIO                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RUTERO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_SALIDA                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_SOLIMP                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TASACAMBIO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TERCERO                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TRANSFER                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TRASLACAJA                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TRASLADOS                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_VACACIONES                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PEDWEB                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTASESTADOS                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBPRECIO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_SORTEO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ARQUEO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_LIQUIDACION                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TAXINST                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEPRECIA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVCARGOEMP                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVVINCULEMP                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CLIFACT                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSNOMINA                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_IMPORTA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AUTOCART                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EVENEXIS                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_GASTOIMP                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRUEBA                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONCILIAPATD                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DETCART                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONTRATOC                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_LIQRUTA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECAUDO                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RELEVO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REPLEVENTO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PARQUEADERO                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBART                     TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_TICKETS_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_NOTAS_ID            TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_FIRMA_ID            TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_ENVIOS_FO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_BANDEJA_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_TITULOS_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REEMFAC                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENSERV                   TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_CHAT                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DOMICILIO_SENVIO            TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_CAMBIOS_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PROGPAGO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_VACACOL                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DENOMINA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMINAEXTRA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EMBARGO                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECAPP                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTCARAPP                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DOCINVWEB                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COSTONEG                    TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_CONEXION_ID         TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_AGENDA_CLIENTE_ID   TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_AGENDA_PROVEEDOR_ID TO PUBLIC;

GRANT USAGE ON EXCEPTION ABONO_CERO                     TO PUBLIC;
GRANT USAGE ON EXCEPTION AJUSTE_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION ANO_INICIO_INCORRECTO          TO PUBLIC;
GRANT USAGE ON EXCEPTION APLICACIONCL_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION APLICACIONPR_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_CON_MOVIMIENTOS       TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_INACTIVO              TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_REGISTRADO            TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_SIN_PESO              TO PUBLIC;
GRANT USAGE ON EXCEPTION AUTORIZACION_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION AUTORIZACION_YA_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION BANCO_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION BODEGA_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION BONO_USADO                     TO PUBLIC;
GRANT USAGE ON EXCEPTION CAJA_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIODOC_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_CODIGO_CUENTA           TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_FECHA                   TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_SALARIO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION CANTIDAD_CRUCE_MAYOR           TO PUBLIC;
GRANT USAGE ON EXCEPTION CENTRO_CON_MOVIMIENTO          TO PUBLIC;
GRANT USAGE ON EXCEPTION CENTRO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION CIUDAD_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_CON_MOV                TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_CON_MOVIMIENTO         TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION COBRADOR_MOVIMIENTO            TO PUBLIC;
GRANT USAGE ON EXCEPTION COBRADOR_NOREG                 TO PUBLIC;
GRANT USAGE ON EXCEPTION COBRADOR_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION COMISIONES_CALCULADAS          TO PUBLIC;
GRANT USAGE ON EXCEPTION COMISIONES_REGISTRADAS         TO PUBLIC;
GRANT USAGE ON EXCEPTION COMPROBAENCABEZA_NO_EXISTE     TO PUBLIC;
GRANT USAGE ON EXCEPTION COMPROBANTE_DESCUADRADO        TO PUBLIC;
GRANT USAGE ON EXCEPTION COMPROBANTE_REGISTRADO         TO PUBLIC;
GRANT USAGE ON EXCEPTION CONCEPTO_ASIGNADO_EMPLEADO     TO PUBLIC;
GRANT USAGE ON EXCEPTION CONCEPTO_CON_MOVIMIENTO        TO PUBLIC;
GRANT USAGE ON EXCEPTION CONFIGURACION_NO_ENCONTRADA    TO PUBLIC;
GRANT USAGE ON EXCEPTION CONSIGNATAR_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION CONSIGNA_NO_EXISTA             TO PUBLIC;
GRANT USAGE ON EXCEPTION CONSUMO_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION CONTABILIDAD_BLOQUEADA         TO PUBLIC;
GRANT USAGE ON EXCEPTION COTIZACION_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTABANCO_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_CON_HIJAS               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_CON_MOVIMIENTOS         TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_CON_SALDO               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_NO_ES_NORMAL            TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_PADRE_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_SIN_DATOS               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUPO_INSUFICIENTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION DESENSAMBLE_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION DEVOLUCIONPROD_NO_EXISTE       TO PUBLIC;
GRANT USAGE ON EXCEPTION DEVOLUCION_MAYOR               TO PUBLIC;
GRANT USAGE ON EXCEPTION DEVOLUCION_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_ABONO_MAYOR          TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_CONCILIADO           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_CON_ABONOS           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_CRUZADO              TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_DEVUELTO             TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_DE_OTRO_TERCERO      TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_FECHA_ABONO_ANTERIOR TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_PAGO_SALIDO          TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_REFERENCIADO         TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_REGISTRADO           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_TOTALMENTE_CANCELADO TO PUBLIC;
GRANT USAGE ON EXCEPTION EFECTIVO_INSUFICIENTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION EGRESO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION ENSAMBLE_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION ENTRADAPROD_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION ENTRADA_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION ESTRUCTURA_INCORRECTA          TO PUBLIC;
GRANT USAGE ON EXCEPTION EXISTENCIA_INSUFICIENTE        TO PUBLIC;
GRANT USAGE ON EXCEPTION FACTOR_NO_ENCONTRADO           TO PUBLIC;
GRANT USAGE ON EXCEPTION FACTOR_PRECIO_MENOR            TO PUBLIC;
GRANT USAGE ON EXCEPTION FACTURA_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION FALTA_ACTIVO                   TO PUBLIC;
GRANT USAGE ON EXCEPTION FALTA_ARTICULO                 TO PUBLIC;
GRANT USAGE ON EXCEPTION FALTA_BASE                     TO PUBLIC;
GRANT USAGE ON EXCEPTION FECHA_ANTERIOR_DOCUMENTO       TO PUBLIC;
GRANT USAGE ON EXCEPTION FECHA_ANTERIOR_INICIO          TO PUBLIC;
GRANT USAGE ON EXCEPTION FECHA_NO_VALIDA                TO PUBLIC;
GRANT USAGE ON EXCEPTION FORMAPAGO_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION GRUPO_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION HORA_EXTRA_YA_UTILIZADA        TO PUBLIC;
GRANT USAGE ON EXCEPTION INTERFAZ_NO_ENCONTRADA         TO PUBLIC;
GRANT USAGE ON EXCEPTION LISTA_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_CON_MOVIMIENTOS           TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_NEGATIVO                  TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_OBLIGATORIO               TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_PREVIO                    TO PUBLIC;
GRANT USAGE ON EXCEPTION MARCA_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION MES_YA_FACTURADO               TO PUBLIC;
GRANT USAGE ON EXCEPTION MOVIMIENTO_CUENTA_PADRE        TO PUBLIC;
GRANT USAGE ON EXCEPTION MOVIMIENTO_NO_CARTERA          TO PUBLIC;
GRANT USAGE ON EXCEPTION MOVIMIENTO_NO_INVENTARIO       TO PUBLIC;
GRANT USAGE ON EXCEPTION NIVEL_NO_AFECTABLE             TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_CON_PAGO                TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_OTRO_PERIODO            TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_REGISTRADA              TO PUBLIC;
GRANT USAGE ON EXCEPTION NO_HAY_BONO_DE_PAGO            TO PUBLIC;
GRANT USAGE ON EXCEPTION ORDEN_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION PAGO_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION PEDIDO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION PLANTILLA_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJOBANCO_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJO_CONTA_NOEXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJO_DEVCHEQUE              TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJO_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION PRODUCCION_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION PROVEEDOR_CON_MOV              TO PUBLIC;
GRANT USAGE ON EXCEPTION PROVEEDOR_CON_MOVIMIENTO       TO PUBLIC;
GRANT USAGE ON EXCEPTION PROVEEDOR_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION PROYECTO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION PUNTOVTA_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION RANGO_DIAS_INCONSISTENTE       TO PUBLIC;
GRANT USAGE ON EXCEPTION RECIBO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION REMISION_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION RUTA_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDOCTA_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDO_INSUFICIENTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDO_SIN_CUENTA               TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDO_SIN_TERCERO              TO PUBLIC;
GRANT USAGE ON EXCEPTION SALIDAPROD_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION SALIDA_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_ICPE                       TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UCC                        TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UCCP                       TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UCPE                       TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UPR                        TO PUBLIC;
GRANT USAGE ON EXCEPTION SUBGRUPO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION SUCURSAL_CON_MOVIMIENTOS       TO PUBLIC;
GRANT USAGE ON EXCEPTION TARJETA_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION TASA_CAMBIO_REGISTRADA         TO PUBLIC;
GRANT USAGE ON EXCEPTION TERCERO_CON_MOV                TO PUBLIC;
GRANT USAGE ON EXCEPTION TERCERO_CON_SALDO              TO PUBLIC;
GRANT USAGE ON EXCEPTION TERCERO_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION TIPOCOMP_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION TIPODOC_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION TIQUETE_USADO                  TO PUBLIC;
GRANT USAGE ON EXCEPTION TRASFERENCIA_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION UNIDAD_CON_MOV                 TO PUBLIC;
GRANT USAGE ON EXCEPTION UNIDAD_NO_REGISTRADA           TO PUBLIC;
GRANT USAGE ON EXCEPTION VEHICULO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION VENDEDOR_MOVIMIENTO            TO PUBLIC;
GRANT USAGE ON EXCEPTION VENDEDOR_NOREG                 TO PUBLIC;
GRANT USAGE ON EXCEPTION YA_EXISTE_EL_REGISTRO          TO PUBLIC;
GRANT USAGE ON EXCEPTION interfaz_no_definida           TO PUBLIC;
GRANT USAGE ON EXCEPTION CONCEPTO_CONTABLE_USADO        TO PUBLIC;
GRANT USAGE ON EXCEPTION ANTICPO_SIN_ORIGEN             TO PUBLIC;
GRANT USAGE ON EXCEPTION NOTA_YA_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_CON_EXISTENCIA        TO PUBLIC;
GRANT USAGE ON EXCEPTION PERIODO_PAGADO                 TO PUBLIC;
GRANT USAGE ON EXCEPTION SORTEO_YA_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION DATO_OBLIGATORIO               TO PUBLIC;
GRANT USAGE ON EXCEPTION ABONO_PRESTAMO_MAYOR           TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_INACTIVO               TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_CARGO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_VINCUL_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_CON_APORTES             TO PUBLIC;
GRANT USAGE ON EXCEPTION VENCIMIENTO_INCORRECTO         TO PUBLIC;
GRANT USAGE ON EXCEPTION SERIAL_YA_USADO                TO PUBLIC;
GRANT USAGE ON EXCEPTION ACTIVO_SIN_MESES_DEPRECIACION  TO PUBLIC;
GRANT USAGE ON EXCEPTION ACTIVO_SIN_CUENTA              TO PUBLIC;
GRANT USAGE ON EXCEPTION EXISTENCIA_SOBRE_MAXIMO        TO PUBLIC;
GRANT USAGE ON EXCEPTION CODIGO_EAN_INCORRECTO          TO PUBLIC;
GRANT USAGE ON EXCEPTION DESCUENTO_MAYOR_AL_TOTAL       TO PUBLIC;
GRANT USAGE ON EXCEPTION PRECIO_MAYOR_TOPE              TO PUBLIC;
GRANT USAGE ON EXCEPTION CANTIDAD_MAYOR_DESCUENTO       TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION AHORRO_MENOR                   TO PUBLIC;
GRANT USAGE ON EXCEPTION LISTA_IGUAL_BASE               TO PUBLIC;
GRANT USAGE ON EXCEPTION EMPLEADO_CON_MOVIMIENTO        TO PUBLIC;


GRANT ALL ON TABLE RDB$PAGES                      TO PUBLIC;
GRANT ALL ON TABLE RDB$DATABASE                   TO PUBLIC;
GRANT ALL ON TABLE RDB$FIELDS                     TO PUBLIC;
GRANT ALL ON TABLE RDB$INDEX_SEGMENTS             TO PUBLIC;
GRANT ALL ON TABLE RDB$INDICES                    TO PUBLIC;
GRANT ALL ON TABLE RDB$RELATION_FIELDS            TO PUBLIC;
GRANT ALL ON TABLE RDB$RELATIONS                  TO PUBLIC;
GRANT ALL ON TABLE RDB$VIEW_RELATIONS             TO PUBLIC;
GRANT ALL ON TABLE RDB$FORMATS                    TO PUBLIC;
GRANT ALL ON TABLE RDB$SECURITY_CLASSES           TO PUBLIC;
GRANT ALL ON TABLE RDB$FILES                      TO PUBLIC;
GRANT ALL ON TABLE RDB$TYPES                      TO PUBLIC;
GRANT ALL ON TABLE RDB$TRIGGERS                   TO PUBLIC;
GRANT ALL ON TABLE RDB$DEPENDENCIES               TO PUBLIC;
GRANT ALL ON TABLE RDB$FUNCTIONS                  TO PUBLIC;
GRANT ALL ON TABLE RDB$FUNCTION_ARGUMENTS         TO PUBLIC;
GRANT ALL ON TABLE RDB$FILTERS                    TO PUBLIC;
GRANT ALL ON TABLE RDB$TRIGGER_MESSAGES           TO PUBLIC;
GRANT ALL ON TABLE RDB$USER_PRIVILEGES            TO PUBLIC;
GRANT ALL ON TABLE RDB$TRANSACTIONS               TO PUBLIC;
GRANT ALL ON TABLE RDB$GENERATORS                 TO PUBLIC;
GRANT ALL ON TABLE RDB$FIELD_DIMENSIONS           TO PUBLIC;
GRANT ALL ON TABLE RDB$RELATION_CONSTRAINTS       TO PUBLIC;
GRANT ALL ON TABLE RDB$REF_CONSTRAINTS            TO PUBLIC;
GRANT ALL ON TABLE RDB$CHECK_CONSTRAINTS          TO PUBLIC;
GRANT ALL ON TABLE RDB$LOG_FILES                  TO PUBLIC;
GRANT ALL ON TABLE RDB$PROCEDURES                 TO PUBLIC;
GRANT ALL ON TABLE RDB$PROCEDURE_PARAMETERS       TO PUBLIC;
GRANT ALL ON TABLE RDB$CHARACTER_SETS             TO PUBLIC;
GRANT ALL ON TABLE RDB$COLLATIONS                 TO PUBLIC;
GRANT ALL ON TABLE RDB$EXCEPTIONS                 TO PUBLIC;
GRANT ALL ON TABLE RDB$ROLES                      TO PUBLIC;
GRANT ALL ON TABLE RDB$BACKUP_HISTORY             TO PUBLIC;
GRANT ALL ON TABLE MON$DATABASE                   TO PUBLIC;
GRANT ALL ON TABLE MON$ATTACHMENTS                TO PUBLIC;
GRANT ALL ON TABLE MON$TRANSACTIONS               TO PUBLIC;
GRANT ALL ON TABLE MON$STATEMENTS                 TO PUBLIC;
GRANT ALL ON TABLE MON$CALL_STACK                 TO PUBLIC;
GRANT ALL ON TABLE MON$IO_STATS                   TO PUBLIC;
GRANT ALL ON TABLE MON$RECORD_STATS               TO PUBLIC;
GRANT ALL ON TABLE MON$CONTEXT_VARIABLES          TO PUBLIC;
GRANT ALL ON TABLE MON$MEMORY_USAGE               TO PUBLIC;
GRANT ALL ON TABLE RDB$PACKAGES                   TO PUBLIC;
GRANT ALL ON TABLE SEC$USERS                      TO PUBLIC;
GRANT ALL ON TABLE SEC$USER_ATTRIBUTES            TO PUBLIC;
GRANT ALL ON TABLE RDB$AUTH_MAPPING               TO PUBLIC;
GRANT ALL ON TABLE SEC$GLOBAL_AUTH_MAPPING        TO PUBLIC;
GRANT ALL ON TABLE RDB$DB_CREATORS                TO PUBLIC;
GRANT ALL ON TABLE SEC$DB_CREATORS                TO PUBLIC;
GRANT ALL ON TABLE MON$TABLE_STATS                TO PUBLIC;
GRANT ALL ON TABLE ACCESO_USUARIO                 TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_BANCOS_NIIF           TO PUBLIC;
GRANT ALL ON TABLE ACTIVOS_FIJOS                  TO PUBLIC;
GRANT ALL ON TABLE ADMINISTRADORA                 TO PUBLIC;
GRANT ALL ON TABLE REPORT_ACTUALIZACION           TO PUBLIC;
GRANT ALL ON TABLE AFP_ESPECIAL                   TO PUBLIC;
GRANT ALL ON TABLE REPORT_PERMISOS                TO PUBLIC;
GRANT ALL ON TABLE AJUSTE_CIERRE                  TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_CERTRETE             TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_NOMINA_REPORTE       TO PUBLIC;
GRANT ALL ON TABLE SORTEOS_CONFIGURACION          TO PUBLIC;
GRANT ALL ON TABLE AJUSTES                        TO PUBLIC;
GRANT ALL ON TABLE SORTEO_FACTURA                 TO PUBLIC;
GRANT ALL ON TABLE AJUSTES_DETALLE                TO PUBLIC;
GRANT ALL ON TABLE AJUSTES_INFLACION              TO PUBLIC;
GRANT ALL ON TABLE ANALISIS_ABCINVEN              TO PUBLIC;
GRANT ALL ON TABLE REPLICA_CONTA                  TO PUBLIC;
GRANT ALL ON TABLE ANTICIPOS_CLIENTE              TO PUBLIC;
GRANT ALL ON TABLE ANTICIPOS_NOMINA               TO PUBLIC;
GRANT ALL ON TABLE ANTICIPOS_PROVEEDOR            TO PUBLIC;
GRANT ALL ON TABLE APLICACION_CLIENTE             TO PUBLIC;
GRANT ALL ON TABLE APLICACION_CLIENTE_CRUCE       TO PUBLIC;
GRANT ALL ON TABLE APLICACION_CLIENTE_DETALLE     TO PUBLIC;
GRANT ALL ON TABLE NOMINA_UGPP_MESES              TO PUBLIC;
GRANT ALL ON TABLE APLICACION_PROVEDOR            TO PUBLIC;
GRANT ALL ON TABLE APLICACION_PROVEEDOR_DETALLE   TO PUBLIC;
GRANT ALL ON TABLE DESCUENTOS_PRECIOS_CLI         TO PUBLIC;
GRANT ALL ON TABLE AREA                           TO PUBLIC;
GRANT ALL ON TABLE REPORT_AREA                    TO PUBLIC;
GRANT ALL ON TABLE TIPO_VINCULO_UGPP              TO PUBLIC;
GRANT ALL ON TABLE DESCUENTOS_PRECIOS_DET         TO PUBLIC;
GRANT ALL ON TABLE ARTICULO                       TO PUBLIC;
GRANT ALL ON TABLE CAMBIO_ARTICULOS               TO PUBLIC;
GRANT ALL ON TABLE INGRESOS_EMPLEADO              TO PUBLIC;
GRANT ALL ON TABLE ARTICULO_ALERTAS               TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_CARGO_EMPLEADO      TO PUBLIC;
GRANT ALL ON TABLE REPORT_TEMAS                   TO PUBLIC;
GRANT ALL ON TABLE REPLICA_CONTA_DETALLE          TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_VINCUL_EMPLEADO     TO PUBLIC;
GRANT ALL ON TABLE ARTICULOS_PRODUCTO             TO PUBLIC;
GRANT ALL ON TABLE ASEGURADORA                    TO PUBLIC;
GRANT ALL ON TABLE ENSAMBLE_TURNO                 TO PUBLIC;
GRANT ALL ON TABLE ARTICULOS_REPORTE              TO PUBLIC;
GRANT ALL ON TABLE ASESORES                       TO PUBLIC;
GRANT ALL ON TABLE AUDITORIA                      TO PUBLIC;
GRANT ALL ON TABLE AUTORIZACIONES                 TO PUBLIC;
GRANT ALL ON TABLE BANCOS                         TO PUBLIC;
GRANT ALL ON TABLE BARRAS_ARTICULO                TO PUBLIC;
GRANT ALL ON TABLE BODEGA                         TO PUBLIC;
GRANT ALL ON TABLE REPLICA_COMPRAS                TO PUBLIC;
GRANT ALL ON TABLE BONOS_PAGO                     TO PUBLIC;
GRANT ALL ON TABLE TERMINOS_PAGO                  TO PUBLIC;
GRANT ALL ON TABLE CAJAS                          TO PUBLIC;
GRANT ALL ON TABLE REPORT_OBSERVACIONES           TO PUBLIC;
GRANT ALL ON TABLE CAJEROS                        TO PUBLIC;
GRANT ALL ON TABLE CAMBIA_COSTOS                  TO PUBLIC;
GRANT ALL ON TABLE FACTURA_ALQUILER               TO PUBLIC;
GRANT ALL ON TABLE CAMBIO_DOCUMENTOS              TO PUBLIC;
GRANT ALL ON TABLE CAMBIO_SITUACION               TO PUBLIC;
GRANT ALL ON TABLE CAMBIODOC_ENTRADAS             TO PUBLIC;
GRANT ALL ON TABLE CAMBIODOC_SALIDAS              TO PUBLIC;
GRANT ALL ON TABLE TERMINOS_ENTREGA               TO PUBLIC;
GRANT ALL ON TABLE CANAL                          TO PUBLIC;
GRANT ALL ON TABLE CARGA_REMESA                   TO PUBLIC;
GRANT ALL ON TABLE CARTAS_NOMINA                  TO PUBLIC;
GRANT ALL ON TABLE REPORT_TICKETS                 TO PUBLIC;
GRANT ALL ON TABLE CENTROS                        TO PUBLIC;
GRANT ALL ON TABLE MEDIOSMAG_ARCHIVOS2014         TO PUBLIC;
GRANT ALL ON TABLE CESANTIA_DETALLE               TO PUBLIC;
GRANT ALL ON TABLE CESANTIAS                      TO PUBLIC;
GRANT ALL ON TABLE CESANTIAS_RETIROS              TO PUBLIC;
GRANT ALL ON TABLE CHEQUERA                       TO PUBLIC;
GRANT ALL ON TABLE CHEQUES                        TO PUBLIC;
GRANT ALL ON TABLE NORMAS_NIIF                    TO PUBLIC;
GRANT ALL ON TABLE CIERRE_ANUAL                   TO PUBLIC;
GRANT ALL ON TABLE CIERRE_TERCEROS                TO PUBLIC;
GRANT ALL ON TABLE NORMAS_NIIF_DETALLE            TO PUBLIC;
GRANT ALL ON TABLE CIUDADES                       TO PUBLIC;
GRANT ALL ON TABLE CLASE_EGRESO                   TO PUBLIC;
GRANT ALL ON TABLE CLIENTE_SUCURSALES             TO PUBLIC;
GRANT ALL ON TABLE CLIENTES                       TO PUBLIC;
GRANT ALL ON TABLE CLIENTES_ALERTAS               TO PUBLIC;
GRANT ALL ON TABLE COBRADORES                     TO PUBLIC;
GRANT ALL ON TABLE COMISION_COBRO                 TO PUBLIC;
GRANT ALL ON TABLE REPORT_TITULOS                 TO PUBLIC;
GRANT ALL ON TABLE COMISIONES                     TO PUBLIC;
GRANT ALL ON TABLE COMISIONES_POR_PAGAR           TO PUBLIC;
GRANT ALL ON TABLE COMISIONES_PUNTOS              TO PUBLIC;
GRANT ALL ON TABLE COMPRAS_INTERNACIONALES        TO PUBLIC;
GRANT ALL ON TABLE REPORT_NOTAS                   TO PUBLIC;
GRANT ALL ON TABLE COMPRAS_INTERNACIONALES_DETALLETO PUBLIC;
GRANT ALL ON TABLE ARTICULO_BODEGA                TO PUBLIC;
GRANT ALL ON TABLE COMPROBANTE_DETALLE            TO PUBLIC;
GRANT ALL ON TABLE COMPROBANTE_ENCABEZADO         TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_CONTADO_PAGO          TO PUBLIC;
GRANT ALL ON TABLE CONCEPTO_CONTABLE              TO PUBLIC;
GRANT ALL ON TABLE DESCUENTOS_PRECIOS             TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS                      TO PUBLIC;
GRANT ALL ON TABLE PEDIDO_WEB                     TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_CUENTAS              TO PUBLIC;
GRANT ALL ON TABLE PEDIDO_WEB_DETALLE             TO PUBLIC;
GRANT ALL ON TABLE CUENTAS_REPORTE_CERTDET        TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_CXPAGAR              TO PUBLIC;
GRANT ALL ON TABLE EXISTENCIA_TERCERO             TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_NOMINA               TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_PLANILLA             TO PUBLIC;
GRANT ALL ON TABLE CONCILIA_BANCO_CONTA_AUX       TO PUBLIC;
GRANT ALL ON TABLE CONCILIACION_BANCARIA          TO PUBLIC;
GRANT ALL ON TABLE CONCILIACION_DETALLE           TO PUBLIC;
GRANT ALL ON TABLE CONCILIACION_ENCABEZADO        TO PUBLIC;
GRANT ALL ON TABLE CONCILIACION_OPERACIONES       TO PUBLIC;
GRANT ALL ON TABLE HEMOLIFE_CLIENTES              TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_MEDIOSMAG            TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_POS                  TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_TIENDAV              TO PUBLIC;
GRANT ALL ON TABLE CONFIGURACION                  TO PUBLIC;
GRANT ALL ON TABLE CONFIGURACION_HORAS_EMPLEADO   TO PUBLIC;
GRANT ALL ON TABLE CONFIRMACION_DEPOSITO          TO PUBLIC;
GRANT ALL ON TABLE CONSIGNA                       TO PUBLIC;
GRANT ALL ON TABLE CONSIGNA_DETALLE               TO PUBLIC;
GRANT ALL ON TABLE CONSIGNA_RECIBOS               TO PUBLIC;
GRANT ALL ON TABLE CONSIGNA_TARJETAS              TO PUBLIC;
GRANT ALL ON TABLE CONSIGNA_TARJETAS_DET          TO PUBLIC;
GRANT ALL ON TABLE CONSOLIDADO_FALTANTES          TO PUBLIC;
GRANT ALL ON TABLE CONSOLIDADO_NOMINA             TO PUBLIC;
GRANT ALL ON TABLE CONSOLIDADO_NOMINA_PROV        TO PUBLIC;
GRANT ALL ON TABLE NOMINA_SALDINI                 TO PUBLIC;
GRANT ALL ON TABLE CONSOLIDE_DOCS                 TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_VENTAS_NIIF           TO PUBLIC;
GRANT ALL ON TABLE CONSOLIDE_FALTANTES            TO PUBLIC;
GRANT ALL ON TABLE COSTO_VENTAS_NIIF              TO PUBLIC;
GRANT ALL ON TABLE CONSOLIDE_FORMASP              TO PUBLIC;
GRANT ALL ON TABLE CONSULTA_BALANCE               TO PUBLIC;
GRANT ALL ON TABLE CONSUMO_DETALLE                TO PUBLIC;
GRANT ALL ON TABLE CONSUMOS                       TO PUBLIC;
GRANT ALL ON TABLE CONTABIL_ARTICULO              TO PUBLIC;
GRANT ALL ON TABLE CONTABILIZACION                TO PUBLIC;
GRANT ALL ON TABLE CONTABILIZACION_DET            TO PUBLIC;
GRANT ALL ON TABLE COSTO_VENTAS                   TO PUBLIC;
GRANT ALL ON TABLE COSTOS                         TO PUBLIC;
GRANT ALL ON TABLE HEMOLIFE_REMISIONES            TO PUBLIC;
GRANT ALL ON TABLE DENOMINACIONES                 TO PUBLIC;
GRANT ALL ON TABLE COTIZACION_PROVEEDOR           TO PUBLIC;
GRANT ALL ON TABLE ARQUEO_CAJA                    TO PUBLIC;
GRANT ALL ON TABLE COTIZACIONES                   TO PUBLIC;
GRANT ALL ON TABLE ARQUEO_CAJA_DET                TO PUBLIC;
GRANT ALL ON TABLE COTIZACIONES_DETALLE           TO PUBLIC;
GRANT ALL ON TABLE COTIZACIONES_PROVEEDOR_DET     TO PUBLIC;
GRANT ALL ON TABLE CRM_ACTIVIDAD                  TO PUBLIC;
GRANT ALL ON TABLE CRM_AGRUPACION                 TO PUBLIC;
GRANT ALL ON TABLE CRM_ASESOR                     TO PUBLIC;
GRANT ALL ON TABLE CRM_CAMPANA                    TO PUBLIC;
GRANT ALL ON TABLE CRM_CAMPANA_DETALLE            TO PUBLIC;
GRANT ALL ON TABLE CRM_CAMPANA_MOTIVOS            TO PUBLIC;
GRANT ALL ON TABLE CRM_CAMPANA_PLANILLA           TO PUBLIC;
GRANT ALL ON TABLE CRM_CAMPANA_RESPUESTAS         TO PUBLIC;
GRANT ALL ON TABLE CRM_CARGOS                     TO PUBLIC;
GRANT ALL ON TABLE CRM_CLASE                      TO PUBLIC;
GRANT ALL ON TABLE CRM_CLIENTES                   TO PUBLIC;
GRANT ALL ON TABLE CRM_COMPROMISOS                TO PUBLIC;
GRANT ALL ON TABLE CRM_CONTACTOS                  TO PUBLIC;
GRANT ALL ON TABLE COTIZACION_WEB                 TO PUBLIC;
GRANT ALL ON TABLE ARTICULO_EQUIVALENCIA          TO PUBLIC;
GRANT ALL ON TABLE CRM_ESTADO                     TO PUBLIC;
GRANT ALL ON TABLE CRM_EVENTO_MOTIVO              TO PUBLIC;
GRANT ALL ON TABLE CRM_EVENTO_RESPUESTA           TO PUBLIC;
GRANT ALL ON TABLE GASTOS_IMPORTACION             TO PUBLIC;
GRANT ALL ON TABLE CRM_EVENTOS                    TO PUBLIC;
GRANT ALL ON TABLE REPORT_LOGO                    TO PUBLIC;
GRANT ALL ON TABLE COTIZACION_WEB_DETALLE         TO PUBLIC;
GRANT ALL ON TABLE IMPORTACION_LIQUIDACION        TO PUBLIC;
GRANT ALL ON TABLE CRM_PRODUCTOS                  TO PUBLIC;
GRANT ALL ON TABLE REPORT_FIRMA                   TO PUBLIC;
GRANT ALL ON TABLE CRM_SUBPRODUCTOS               TO PUBLIC;
GRANT ALL ON TABLE CRM_TIPO_ACTIVIDAD             TO PUBLIC;
GRANT ALL ON TABLE CRM_TIPOCONTACTO               TO PUBLIC;
GRANT ALL ON TABLE COCINA_OPERARIOS               TO PUBLIC;
GRANT ALL ON TABLE CRM_TIPOEVENTO                 TO PUBLIC;
GRANT ALL ON TABLE CRM_TIPORELACION               TO PUBLIC;
GRANT ALL ON TABLE DOCUMENTOS_ESTADO              TO PUBLIC;
GRANT ALL ON TABLE CUENTAS                        TO PUBLIC;
GRANT ALL ON TABLE CUENTAS_BANCO                  TO PUBLIC;
GRANT ALL ON TABLE CUENTAS_EXPORTACION            TO PUBLIC;
GRANT ALL ON TABLE DEPARTAMENTO                   TO PUBLIC;
GRANT ALL ON TABLE RECIBOS_PRESTAMOS              TO PUBLIC;
GRANT ALL ON TABLE DEPOSITOS                      TO PUBLIC;
GRANT ALL ON TABLE REPORT_PREFIJOS                TO PUBLIC;
GRANT ALL ON TABLE DESENSAMBLES                   TO PUBLIC;
GRANT ALL ON TABLE DESENSAMBLES_DETALLE           TO PUBLIC;
GRANT ALL ON TABLE FACTURA_EMBALAJE               TO PUBLIC;
GRANT ALL ON TABLE DEVOLUCION_CHEQUES             TO PUBLIC;
GRANT ALL ON TABLE DEVOLUCION_COMPRAS_DOCRELA     TO PUBLIC;
GRANT ALL ON TABLE DEVOLUCIONES_COMPRAS           TO PUBLIC;
GRANT ALL ON TABLE DEVOLUCIONES_COMPRAS_DET       TO PUBLIC;
GRANT ALL ON TABLE DEVOLUCIONES_VENTAS            TO PUBLIC;
GRANT ALL ON TABLE DEVOLUCIONES_VENTAS_DETALLE    TO PUBLIC;
GRANT ALL ON TABLE DEVOLUCIONES_VENTAS_DOCRELA    TO PUBLIC;
GRANT ALL ON TABLE DOCUMENTOS_CONTA               TO PUBLIC;
GRANT ALL ON TABLE DOCUMENTOS_IMPORT_EMPLEADO     TO PUBLIC;
GRANT ALL ON TABLE CAMBIO_SITUACION_NIIF          TO PUBLIC;
GRANT ALL ON TABLE DOCUMENTOS_PAGO_CAJA           TO PUBLIC;
GRANT ALL ON TABLE EDUCACION_FORMAL_EMPLEADO      TO PUBLIC;
GRANT ALL ON TABLE EGRESOS                        TO PUBLIC;
GRANT ALL ON TABLE EGRESOS_BANCO                  TO PUBLIC;
GRANT ALL ON TABLE EGRESOS_CAJA                   TO PUBLIC;
GRANT ALL ON TABLE EGRESOS_CONTABILIDAD           TO PUBLIC;
GRANT ALL ON TABLE EGRESOS_CRUCEC                 TO PUBLIC;
GRANT ALL ON TABLE EGRESOS_DETALLE                TO PUBLIC;
GRANT ALL ON TABLE EGRESOS_NOMINA                 TO PUBLIC;
GRANT ALL ON TABLE EMPLEADO_BENEFICIARIOS         TO PUBLIC;
GRANT ALL ON TABLE EMPLEADO_CONCEPTOS             TO PUBLIC;
GRANT ALL ON TABLE REPORT_CONFIGURACION           TO PUBLIC;
GRANT ALL ON TABLE EMPLEADO_FORMACION             TO PUBLIC;
GRANT ALL ON TABLE EMPLEADO_LLAMADOS              TO PUBLIC;
GRANT ALL ON TABLE REPORT_ENVIOS_FALTANTES        TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_COMPRAS_NIIF          TO PUBLIC;
GRANT ALL ON TABLE EMPLEADOS                      TO PUBLIC;
GRANT ALL ON TABLE ENSAMBLE_MAQUINA               TO PUBLIC;
GRANT ALL ON TABLE ENSAMBLE_OPERARIO              TO PUBLIC;
GRANT ALL ON TABLE ACTIVOS_GRUPOS                 TO PUBLIC;
GRANT ALL ON TABLE ENSAMBLES                      TO PUBLIC;
GRANT ALL ON TABLE ENSAMBLES_DETALLE              TO PUBLIC;
GRANT ALL ON TABLE ENTRADAS                       TO PUBLIC;
GRANT ALL ON TABLE ACTIVACION                     TO PUBLIC;
GRANT ALL ON TABLE ENTRADAS_DETALLE               TO PUBLIC;
GRANT ALL ON TABLE ENTRADAS_SALIDAS_EMPLEADO      TO PUBLIC;
GRANT ALL ON TABLE REPLICACION_CONFIGURA          TO PUBLIC;
GRANT ALL ON TABLE ENTREGA_DOCUMENTOS             TO PUBLIC;
GRANT ALL ON TABLE REPLICA_EVENTOS                TO PUBLIC;
GRANT ALL ON TABLE ENTREGADORES                   TO PUBLIC;
GRANT ALL ON TABLE ENVIO_AUTO                     TO PUBLIC;
GRANT ALL ON TABLE ENVIO_ERRORES                  TO PUBLIC;
GRANT ALL ON TABLE ENVIO_RESUMDIA                 TO PUBLIC;
GRANT ALL ON TABLE CONSOLIDE_NOMINAS              TO PUBLIC;
GRANT ALL ON TABLE ACTIVOS_CENTROS                TO PUBLIC;
GRANT ALL ON TABLE ERRORES                        TO PUBLIC;
GRANT ALL ON TABLE ERRORES_ENVIO_CORREO           TO PUBLIC;
GRANT ALL ON TABLE ERRORES_LOTES                  TO PUBLIC;
GRANT ALL ON TABLE ESTADO_ARTICULO                TO PUBLIC;
GRANT ALL ON TABLE SALDO_BANCOS_CONF              TO PUBLIC;
GRANT ALL ON TABLE ESTRUCTURA                     TO PUBLIC;
GRANT ALL ON TABLE EXISTENCIA                     TO PUBLIC;
GRANT ALL ON TABLE EXISTENCIA_LOTE                TO PUBLIC;
GRANT ALL ON TABLE ACTIVOS_FIJOS_VALOR            TO PUBLIC;
GRANT ALL ON TABLE EXPERIENCIA_LABORAL_EMPLEADO   TO PUBLIC;
GRANT ALL ON TABLE FACTOR_COSTO                   TO PUBLIC;
GRANT ALL ON TABLE ARTICULO_DOCUMENTOS            TO PUBLIC;
GRANT ALL ON TABLE FACTOR_INVENTARIO              TO PUBLIC;
GRANT ALL ON TABLE FACTURA_CONCEPTO               TO PUBLIC;
GRANT ALL ON TABLE FACTURA_CONCEPTO_ITEMS         TO PUBLIC;
GRANT ALL ON TABLE FACTURA_PROFORMA               TO PUBLIC;
GRANT ALL ON TABLE FACTURA_PROFORMA_DET           TO PUBLIC;
GRANT ALL ON TABLE PROGRAMACION_PAGOS             TO PUBLIC;
GRANT ALL ON TABLE HEMOLIFE_DEVOLUCIONES          TO PUBLIC;
GRANT ALL ON TABLE FACTURA_PROFORMA_GASTOS        TO PUBLIC;
GRANT ALL ON TABLE FACTURAS                       TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_COMPRA                TO PUBLIC;
GRANT ALL ON TABLE RETENCION_MINIMA               TO PUBLIC;
GRANT ALL ON TABLE AUTORIZACIONES_CARTERA         TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_COMPRAS_DETALLE       TO PUBLIC;
GRANT ALL ON TABLE COSTOS_NIIF                    TO PUBLIC;
GRANT ALL ON TABLE PERFIL_EMPLEADO                TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_CONTADO               TO PUBLIC;
GRANT ALL ON TABLE PERFIL_EMPLEADO_DETALLE        TO PUBLIC;
GRANT ALL ON TABLE PARQUEADERO                    TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_CONTADO_DETALLE       TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_DETALLE               TO PUBLIC;
GRANT ALL ON TABLE VALORES_NOMINA                 TO PUBLIC;
GRANT ALL ON TABLE NOTA_DEBITO_PROV_DET           TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_MES                   TO PUBLIC;
GRANT ALL ON TABLE NOTA_CREDITO_PROV_DET          TO PUBLIC;
GRANT ALL ON TABLE FLUJO_EFECTIVO                 TO PUBLIC;
GRANT ALL ON TABLE FODO_SOL_PENSIONAL             TO PUBLIC;
GRANT ALL ON TABLE FORMA_PAGO_REMESA              TO PUBLIC;
GRANT ALL ON TABLE ACTIVOS_SUBGRUPO               TO PUBLIC;
GRANT ALL ON TABLE FORMA_PAGOS                    TO PUBLIC;
GRANT ALL ON TABLE FORMAS_PAGO                    TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_CERTRETEL            TO PUBLIC;
GRANT ALL ON TABLE FORMATO_DATOS                  TO PUBLIC;
GRANT ALL ON TABLE FORMATO_LINEAS                 TO PUBLIC;
GRANT ALL ON TABLE CUENTAS_NIIF                   TO PUBLIC;
GRANT ALL ON TABLE FORMATOCONTABLE_DETALLE        TO PUBLIC;
GRANT ALL ON TABLE DEPRECIACION                   TO PUBLIC;
GRANT ALL ON TABLE NOTAS_ESTADOS_FINANCIEROS      TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_CERTRETEL_CONC       TO PUBLIC;
GRANT ALL ON TABLE ACTIVOS_DOCUMENTOS             TO PUBLIC;
GRANT ALL ON TABLE REPORT_BANDEJA                 TO PUBLIC;
GRANT ALL ON TABLE FORMATOCONTABLE_TEXTOS         TO PUBLIC;
GRANT ALL ON TABLE SALDOS_INICIALES_NIIF          TO PUBLIC;
GRANT ALL ON TABLE FORMATOS                       TO PUBLIC;
GRANT ALL ON TABLE FORMATOS_CONTABLES             TO PUBLIC;
GRANT ALL ON TABLE GRUPO                          TO PUBLIC;
GRANT ALL ON TABLE SALDOS_ARTICULO_NIIF           TO PUBLIC;
GRANT ALL ON TABLE GRUPO_CARTERA                  TO PUBLIC;
GRANT ALL ON TABLE SALDOS_CENTROS_NIIF            TO PUBLIC;
GRANT ALL ON TABLE GRUPO_VENDEDOR                 TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CARTERA_NIIF          TO PUBLIC;
GRANT ALL ON TABLE GRUPOS_PROVEEDORES             TO PUBLIC;
GRANT ALL ON TABLE HISTORICO_VENTAS               TO PUBLIC;
GRANT ALL ON TABLE SALDOS_CENTROS_TERCERO_NIIF    TO PUBLIC;
GRANT ALL ON TABLE HORARIO_EMPLEADO               TO PUBLIC;
GRANT ALL ON TABLE HORARIO_EMPLEADO_DET           TO PUBLIC;
GRANT ALL ON TABLE SALDOS_CUENTAS_NIIF            TO PUBLIC;
GRANT ALL ON TABLE IMPORTACION_INVENTARIO         TO PUBLIC;
GRANT ALL ON TABLE SALDOS_TERCEROS_NIIF           TO PUBLIC;
GRANT ALL ON TABLE INCAPACIDADES                  TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_BANCOS                TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_BANCOS_CTAS           TO PUBLIC;
GRANT ALL ON TABLE CONDUCTOR                      TO PUBLIC;
GRANT ALL ON TABLE COMPROBANTE_DETALLE_NIIF       TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CAJA                  TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CAJA_CTAS             TO PUBLIC;
GRANT ALL ON TABLE CLIENTES_FACTURACION_MASIVA    TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CARTERA               TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CARTERA_CTAS          TO PUBLIC;
GRANT ALL ON TABLE PLANTILLA_DETALLE_NIIF         TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_COMPRAS               TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_COMPRAS_CTAS          TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CXPAGAR               TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CXPAGAR_CTAS          TO PUBLIC;
GRANT ALL ON TABLE APERTURA_NIIF                  TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_INVENTARIO            TO PUBLIC;
GRANT ALL ON TABLE SALDOS_ACTIVO_NIIF             TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_INVENTARIO_CTAS       TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_NOMINA                TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_TRANSPORTE            TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_TRANSPORTE_CTAS       TO PUBLIC;
GRANT ALL ON TABLE APERTURA_NIIF_DET              TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_VENTAS                TO PUBLIC;
GRANT ALL ON TABLE TAXONOMIA_ENCABEZADO           TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_VENTAS_CTAS           TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CXPAGAR_NIIF          TO PUBLIC;
GRANT ALL ON TABLE LIQUIDACION                    TO PUBLIC;
GRANT ALL ON TABLE LISTA_PRECIOS                  TO PUBLIC;
GRANT ALL ON TABLE LISTAPREC_VENDEDOR             TO PUBLIC;
GRANT ALL ON TABLE CUENTAS_NIIF_NORMA             TO PUBLIC;
GRANT ALL ON TABLE LLAMADOS_ATENCION              TO PUBLIC;
GRANT ALL ON TABLE LOTES                          TO PUBLIC;
GRANT ALL ON TABLE TAXONOMIA                      TO PUBLIC;
GRANT ALL ON TABLE LISTA_ARTICULOS                TO PUBLIC;
GRANT ALL ON TABLE LUGAR_INSPECCION               TO PUBLIC;
GRANT ALL ON TABLE MANIFIESTO_CARGA               TO PUBLIC;
GRANT ALL ON TABLE MANIFIESTO_CARGA_DET           TO PUBLIC;
GRANT ALL ON TABLE VEHICULOS_HISTORIA             TO PUBLIC;
GRANT ALL ON TABLE LISTA_ARTICULOS_DET            TO PUBLIC;
GRANT ALL ON TABLE MANIFIESTOS_CARGA_CONC         TO PUBLIC;
GRANT ALL ON TABLE REMESAS_DESTINATARIO           TO PUBLIC;
GRANT ALL ON TABLE MARCAS                         TO PUBLIC;
GRANT ALL ON TABLE PREFIJO_PRODUCCION_ORDENAR     TO PUBLIC;
GRANT ALL ON TABLE MEDIOS_MAGNETICOS_DATOS        TO PUBLIC;
GRANT ALL ON TABLE TAXONOMIA_ENCABEZA             TO PUBLIC;
GRANT ALL ON TABLE LISTAS_VENDEDOR                TO PUBLIC;
GRANT ALL ON TABLE MEDIOS_TRANSPORTE              TO PUBLIC;
GRANT ALL ON TABLE IMPORTACION                    TO PUBLIC;
GRANT ALL ON TABLE SERIALES_ARTICULO              TO PUBLIC;
GRANT ALL ON TABLE TAXONOMIA_DETALLE              TO PUBLIC;
GRANT ALL ON TABLE SERIALES_DOCUMENTO             TO PUBLIC;
GRANT ALL ON TABLE MEDIOSMAG_ARCHIVOS             TO PUBLIC;
GRANT ALL ON TABLE CONCILIACION_PAT               TO PUBLIC;
GRANT ALL ON TABLE TAXONOMIA_CUENTAS              TO PUBLIC;
GRANT ALL ON TABLE MEDIOSMAG_CUENTAS              TO PUBLIC;
GRANT ALL ON TABLE REPORT_FALTANTES_TEMP          TO PUBLIC;
GRANT ALL ON TABLE PAGO_NOMINA_EGRESOS            TO PUBLIC;
GRANT ALL ON TABLE TAXONOMIA_INSTANCIA            TO PUBLIC;
GRANT ALL ON TABLE MEDIOSMAG_DISTR_CUENTAS        TO PUBLIC;
GRANT ALL ON TABLE MEDIOSMAG_DISTR_DATOS          TO PUBLIC;
GRANT ALL ON TABLE MEDIOSMAG_DISTRITALES          TO PUBLIC;
GRANT ALL ON TABLE MENSAJERIA                     TO PUBLIC;
GRANT ALL ON TABLE MODO_TRANSPORTE                TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_CAJA_NIIF             TO PUBLIC;
GRANT ALL ON TABLE MODULOS                        TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_ARTICULO            TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_BANCO               TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_CAJA                TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_CLIENTES            TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_PROVEEDOR           TO PUBLIC;
GRANT ALL ON TABLE TERCERO_DOCUMENTOS             TO PUBLIC;
GRANT ALL ON TABLE MOVIMIENTO_SALARIO_EMPLEADO    TO PUBLIC;
GRANT ALL ON TABLE NIVEL_FORMACION                TO PUBLIC;
GRANT ALL ON TABLE NOMBRES_CAMPOS                 TO PUBLIC;
GRANT ALL ON TABLE NOMBRES_COPIAS                 TO PUBLIC;
GRANT ALL ON TABLE NOMINA                         TO PUBLIC;
GRANT ALL ON TABLE CAMBIA_PRECIOS                 TO PUBLIC;
GRANT ALL ON TABLE NOMINA_CARTERA                 TO PUBLIC;
GRANT ALL ON TABLE NOMINA_CARTERA_DETALLE         TO PUBLIC;
GRANT ALL ON TABLE NOMINA_COMISIONES              TO PUBLIC;
GRANT ALL ON TABLE CAMBIO_COSTO                   TO PUBLIC;
GRANT ALL ON TABLE NOMINA_COMISIONES_PROV         TO PUBLIC;
GRANT ALL ON TABLE CONTABIL_ARTICULO_NIIF         TO PUBLIC;
GRANT ALL ON TABLE NOMINA_CONCEPTOS               TO PUBLIC;
GRANT ALL ON TABLE NOMINA_CONCEPTOS_PROV          TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_INVENTARIO_NIIF       TO PUBLIC;
GRANT ALL ON TABLE NOMINA_DEPARTAMENTO            TO PUBLIC;
GRANT ALL ON TABLE NOMINA_DETALLE                 TO PUBLIC;
GRANT ALL ON TABLE NOMINA_DETALLE_PROV            TO PUBLIC;
GRANT ALL ON TABLE NOMINA_HORASEXT                TO PUBLIC;
GRANT ALL ON TABLE LISTAPRE_USUARIOS              TO PUBLIC;
GRANT ALL ON TABLE NOMINA_NOVEDADES               TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_CALIDAD_ITEMS       TO PUBLIC;
GRANT ALL ON TABLE NOMINA_NOVEDADES_DETALLE       TO PUBLIC;
GRANT ALL ON TABLE NOMINA_PROV                    TO PUBLIC;
GRANT ALL ON TABLE NOMINA_VALOR_PREDET            TO PUBLIC;
GRANT ALL ON TABLE NOTAS_CLIENTES                 TO PUBLIC;
GRANT ALL ON TABLE NOTAS_CREDITO                  TO PUBLIC;
GRANT ALL ON TABLE NOTAS_CREDITO_CLIENTES         TO PUBLIC;
GRANT ALL ON TABLE NOTAS_CREDITO_PROVEEDOR        TO PUBLIC;
GRANT ALL ON TABLE CARGA_PRODUCTOS                TO PUBLIC;
GRANT ALL ON TABLE NOTAS_DEBITO                   TO PUBLIC;
GRANT ALL ON TABLE NOTAS_DEBITO_CLIENTES          TO PUBLIC;
GRANT ALL ON TABLE COLORES                        TO PUBLIC;
GRANT ALL ON TABLE NOTAS_DEBITO_PROVEEDOR         TO PUBLIC;
GRANT ALL ON TABLE NOTAS_DOCUMENTO                TO PUBLIC;
GRANT ALL ON TABLE EMPAQUES                       TO PUBLIC;
GRANT ALL ON TABLE NUMERO_COPIA                   TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_ENTRADA_CALIDAD     TO PUBLIC;
GRANT ALL ON TABLE OPCIONES                       TO PUBLIC;
GRANT ALL ON TABLE FACTURA_WEB                    TO PUBLIC;
GRANT ALL ON TABLE OPCIONES_INTERFAZ              TO PUBLIC;
GRANT ALL ON TABLE ORDEN_EMBARQUE                 TO PUBLIC;
GRANT ALL ON TABLE FACTURA_WEB_DETALLE            TO PUBLIC;
GRANT ALL ON TABLE DEPRECIACION_DETALLE           TO PUBLIC;
GRANT ALL ON TABLE ORDENES_COMPRA                 TO PUBLIC;
GRANT ALL ON TABLE HEMOLIFE_ENSAMBLES             TO PUBLIC;
GRANT ALL ON TABLE CONSULTA_WEB                   TO PUBLIC;
GRANT ALL ON TABLE DEPRECIACION_UNIDADES          TO PUBLIC;
GRANT ALL ON TABLE EVENTOS_VENTAS                 TO PUBLIC;
GRANT ALL ON TABLE ORDENES_COMPRA_DETALLE         TO PUBLIC;
GRANT ALL ON TABLE PRUEBAS                        TO PUBLIC;
GRANT ALL ON TABLE PERFIL_PRODUCCION              TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_CERTRETE_NIIF        TO PUBLIC;
GRANT ALL ON TABLE ORDENES_COMPRA_DOCRELA         TO PUBLIC;
GRANT ALL ON TABLE CORREDOR_RUTA                  TO PUBLIC;
GRANT ALL ON TABLE ORDENES_INVENTARIO             TO PUBLIC;
GRANT ALL ON TABLE ORDENINVENTARIO_DETALLE        TO PUBLIC;
GRANT ALL ON TABLE PAGO_APORTES                   TO PUBLIC;
GRANT ALL ON TABLE MAQUINA_PRODUCCION             TO PUBLIC;
GRANT ALL ON TABLE PROVISION_CARTERA              TO PUBLIC;
GRANT ALL ON TABLE SEGMENTOS                      TO PUBLIC;
GRANT ALL ON TABLE PAGO_APORTES_DETALLE           TO PUBLIC;
GRANT ALL ON TABLE PAGO_APORTES_EMPLEADOS         TO PUBLIC;
GRANT ALL ON TABLE HEMOLIFE_EQUIVALENCIAS         TO PUBLIC;
GRANT ALL ON TABLE PAGO_APORTES_NOM               TO PUBLIC;
GRANT ALL ON TABLE PAGO_NOMINA                    TO PUBLIC;
GRANT ALL ON TABLE RUTA_PASAJEROS                 TO PUBLIC;
GRANT ALL ON TABLE PAGO_NOMINA_DET                TO PUBLIC;
GRANT ALL ON TABLE PAISES                         TO PUBLIC;
GRANT ALL ON TABLE VEHICULO_COLOR                 TO PUBLIC;
GRANT ALL ON TABLE PARAMETROS_ANO                 TO PUBLIC;
GRANT ALL ON TABLE PARAMETROS_CONTABLES           TO PUBLIC;
GRANT ALL ON TABLE PARENTESCO                     TO PUBLIC;
GRANT ALL ON TABLE EXISTENCIAS_ARTICULO_WEB       TO PUBLIC;
GRANT ALL ON TABLE PEDIDOS                        TO PUBLIC;
GRANT ALL ON TABLE PEDIDOS_DETALLE                TO PUBLIC;
GRANT ALL ON TABLE PEDIDOS_DOCRELA                TO PUBLIC;
GRANT ALL ON TABLE PENDIENTE_VENTAS               TO PUBLIC;
GRANT ALL ON TABLE PENDIENTE_VENTAS_DETALLE       TO PUBLIC;
GRANT ALL ON TABLE PERIODO_PAGO                   TO PUBLIC;
GRANT ALL ON TABLE PERIODO_PAGO_NOMBRE            TO PUBLIC;
GRANT ALL ON TABLE PLAN_PRODUCCION                TO PUBLIC;
GRANT ALL ON TABLE PLAN_PRODUCCION_CONS           TO PUBLIC;
GRANT ALL ON TABLE PLAN_PRODUCCION_CONS_PROD      TO PUBLIC;
GRANT ALL ON TABLE PLAN_PRODUCCION_DET            TO PUBLIC;
GRANT ALL ON TABLE PLAN_PRODUCCION_PRODUCTOS      TO PUBLIC;
GRANT ALL ON TABLE PLANILLA_DIGITACION            TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_SALIDA_CALIDAD      TO PUBLIC;
GRANT ALL ON TABLE PLANILLA_DIGITACION_CUENTAS    TO PUBLIC;
GRANT ALL ON TABLE ARTICULOS_PERFIL_PROD          TO PUBLIC;
GRANT ALL ON TABLE PLANILLA_PASAJEROS             TO PUBLIC;
GRANT ALL ON TABLE PLANILLA_PASAJEROS_CON         TO PUBLIC;
GRANT ALL ON TABLE PLANILLA_PASAJEROS_DET         TO PUBLIC;
GRANT ALL ON TABLE ARTICULOS_ACTIVOFIJO_PROD      TO PUBLIC;
GRANT ALL ON TABLE PLANILLA_PASAJEROS_REM         TO PUBLIC;
GRANT ALL ON TABLE PLANTILLA_DETALLE              TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_PRODUCCION            TO PUBLIC;
GRANT ALL ON TABLE PLANTILLA_ENCABEZADO           TO PUBLIC;
GRANT ALL ON TABLE PRECIOS_ARTICULO               TO PUBLIC;
GRANT ALL ON TABLE PREFIJOS                       TO PUBLIC;
GRANT ALL ON TABLE PREFIJOS_BANCOS                TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_PRODUCCION_CTAS       TO PUBLIC;
GRANT ALL ON TABLE PREFIJOS_CONTA                 TO PUBLIC;
GRANT ALL ON TABLE PREFIJOS_EXPORTACION           TO PUBLIC;
GRANT ALL ON TABLE PRESTAMO_CUOTAS                TO PUBLIC;
GRANT ALL ON TABLE PRESTAMO_NOMINA                TO PUBLIC;
GRANT ALL ON TABLE PRESUPUESTO                    TO PUBLIC;
GRANT ALL ON TABLE PRESUPUESTO_VENTAS             TO PUBLIC;
GRANT ALL ON TABLE PRESUPUESTO_VENTAS_GRUPO       TO PUBLIC;
GRANT ALL ON TABLE PRESUPUESTO_VENTAS_MESES       TO PUBLIC;
GRANT ALL ON TABLE PROCEDIMIENTOS_USUARIO         TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_DEVOLUCION          TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_DEVOLUCION_DET      TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_ENTRADA_DET         TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_ENTRADA_ENC         TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_MONTAJE             TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_ORDEN               TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_ORDEN_DETALLE       TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_SALIDA_DET          TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_SALIDA_ENC          TO PUBLIC;
GRANT ALL ON TABLE PRODUCTO_MONTAJE               TO PUBLIC;
GRANT ALL ON TABLE PROGRAM_VACACIONES             TO PUBLIC;
GRANT ALL ON TABLE PROGRAMAS                      TO PUBLIC;
GRANT ALL ON TABLE PROMEDIO_SALIDAS               TO PUBLIC;
GRANT ALL ON TABLE PROVEEDOR_ARTICULO             TO PUBLIC;
GRANT ALL ON TABLE PROVEEDORES                    TO PUBLIC;
GRANT ALL ON TABLE PROYECTOS                      TO PUBLIC;
GRANT ALL ON TABLE PUC                            TO PUBLIC;
GRANT ALL ON TABLE PUESTOS                        TO PUBLIC;
GRANT ALL ON TABLE PUNTO_EQUILIBRIO               TO PUBLIC;
GRANT ALL ON TABLE PUNTO_VENTA                    TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_ARTICULOS               TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_CLIENTE                 TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_CLIENTE_ACUMULADO       TO PUBLIC;
GRANT ALL ON TABLE COCINA_FUNCIONES               TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_DIASESPECIAL            TO PUBLIC;
GRANT ALL ON TABLE REEMPLAZO_FACTURA              TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_PREMIOS                 TO PUBLIC;
GRANT ALL ON TABLE REEMPLAZO_FACTURA_DET          TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_REDENCION               TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_VEND_REDENCION          TO PUBLIC;
GRANT ALL ON TABLE COCINA_COLA_FUNCION            TO PUBLIC;
GRANT ALL ON TABLE PUNTOS_VENDEDOR                TO PUBLIC;
GRANT ALL ON TABLE RECIBO_PROVISIONAL             TO PUBLIC;
GRANT ALL ON TABLE RECIBO_PROVISIONAL_DETALLE     TO PUBLIC;
GRANT ALL ON TABLE RECIBO_PROVISIONAL_PAGO        TO PUBLIC;
GRANT ALL ON TABLE RECIBOS_CAJA                   TO PUBLIC;
GRANT ALL ON TABLE RECIBOS_CAJA_CRUCEC            TO PUBLIC;
GRANT ALL ON TABLE ARTICULO_MINIMOS               TO PUBLIC;
GRANT ALL ON TABLE RECIBOS_CAJA_DETALLE           TO PUBLIC;
GRANT ALL ON TABLE RECIBOS_CAJA_PAGO              TO PUBLIC;
GRANT ALL ON TABLE REGISTRO_AUTOMATICO            TO PUBLIC;
GRANT ALL ON TABLE REGISTRO_CONCEPTOS             TO PUBLIC;
GRANT ALL ON TABLE REMISION_PROVEEDOR             TO PUBLIC;
GRANT ALL ON TABLE VENDEDOR_DOCUMENTOS            TO PUBLIC;
GRANT ALL ON TABLE REMISION_PROVEEDOR_DET         TO PUBLIC;
GRANT ALL ON TABLE REMISION_PROVEEDOR_DOCRELA     TO PUBLIC;
GRANT ALL ON TABLE REMISIONES_VENTA               TO PUBLIC;
GRANT ALL ON TABLE REMISIONES_VENTA_DETALLE       TO PUBLIC;
GRANT ALL ON TABLE REMISIONES_VENTA_DOCRELA       TO PUBLIC;
GRANT ALL ON TABLE TARIFAS_ARL                    TO PUBLIC;
GRANT ALL ON TABLE REP_UTILIDAD                   TO PUBLIC;
GRANT ALL ON TABLE REPLICA_ARTICULO_ESTADO        TO PUBLIC;
GRANT ALL ON TABLE REPLICA_COMPANIA               TO PUBLIC;
GRANT ALL ON TABLE REPLICA_VENTAS                 TO PUBLIC;
GRANT ALL ON TABLE REPORTE_ERRORES                TO PUBLIC;
GRANT ALL ON TABLE REPORTES_AUX                   TO PUBLIC;
GRANT ALL ON TABLE REPORTES_MENSAJE               TO PUBLIC;
GRANT ALL ON TABLE RESERVAS                       TO PUBLIC;
GRANT ALL ON TABLE RESERVAS_DETALLE               TO PUBLIC;
GRANT ALL ON TABLE RESPUESTA_TIPOCUENTA           TO PUBLIC;
GRANT ALL ON TABLE RESUMEN_VENTAS                 TO PUBLIC;
GRANT ALL ON TABLE RETENCIONES                    TO PUBLIC;
GRANT ALL ON TABLE RETIROS                        TO PUBLIC;
GRANT ALL ON TABLE REVISION                       TO PUBLIC;
GRANT ALL ON TABLE REVISION_PRECIOS               TO PUBLIC;
GRANT ALL ON TABLE REVPRECIOS_DETALLE             TO PUBLIC;
GRANT ALL ON TABLE RUTAS_ENTREGA                  TO PUBLIC;
GRANT ALL ON TABLE RUTERO                         TO PUBLIC;
GRANT ALL ON TABLE RUTERO_DETALLE                 TO PUBLIC;
GRANT ALL ON TABLE RUTERO_FAC                     TO PUBLIC;
GRANT ALL ON TABLE RUTERO_RAZON                   TO PUBLIC;
GRANT ALL ON TABLE SALDO_BANCOS                   TO PUBLIC;
GRANT ALL ON TABLE SALDO_CAJA                     TO PUBLIC;
GRANT ALL ON TABLE CRM_EVENTOS_NOTAS              TO PUBLIC;
GRANT ALL ON TABLE SALDO_EFECTIVO                 TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_FRECUENTES           TO PUBLIC;
GRANT ALL ON TABLE SALDOS_ACTIVO                  TO PUBLIC;
GRANT ALL ON TABLE EVENTO_EXISTENCIAS             TO PUBLIC;
GRANT ALL ON TABLE SALDOS_ARTICULO                TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_LINKFTP              TO PUBLIC;
GRANT ALL ON TABLE SALDOS_CENTROS                 TO PUBLIC;
GRANT ALL ON TABLE SALDOS_CENTROS_TERCERO         TO PUBLIC;
GRANT ALL ON TABLE SALDOS_CUENTAS                 TO PUBLIC;
GRANT ALL ON TABLE SALDOS_DOC_CARTERA             TO PUBLIC;
GRANT ALL ON TABLE SALDOS_DOC_CXPAGAR             TO PUBLIC;
GRANT ALL ON TABLE FOTOS_ARTICULO                 TO PUBLIC;
GRANT ALL ON TABLE SALDOS_DOCCONTA                TO PUBLIC;
GRANT ALL ON TABLE SALDOS_INICIALES               TO PUBLIC;
GRANT ALL ON TABLE SALDOS_INVENTARIO              TO PUBLIC;
GRANT ALL ON TABLE SALDOS_TERCEROS                TO PUBLIC;
GRANT ALL ON TABLE SALIDAS                        TO PUBLIC;
GRANT ALL ON TABLE SALIDAS_DETALLE                TO PUBLIC;
GRANT ALL ON TABLE SECCION                        TO PUBLIC;
GRANT ALL ON TABLE SOLICITUD_IMPORTACION          TO PUBLIC;
GRANT ALL ON TABLE SOLICITUD_IMPORTACION_DET      TO PUBLIC;
GRANT ALL ON TABLE SOPORTE                        TO PUBLIC;
GRANT ALL ON TABLE STANDS                         TO PUBLIC;
GRANT ALL ON TABLE SUBGRUPO                       TO PUBLIC;
GRANT ALL ON TABLE SUBTIPO_COTIZANTE              TO PUBLIC;
GRANT ALL ON TABLE SUCURSALES                     TO PUBLIC;
GRANT ALL ON TABLE SUPERVISOR                     TO PUBLIC;
GRANT ALL ON TABLE TARIFA_IVA                     TO PUBLIC;
GRANT ALL ON TABLE TARJETAS                       TO PUBLIC;
GRANT ALL ON TABLE TASA_CAMBIO_MONEDA             TO PUBLIC;
GRANT ALL ON TABLE TERCEROS                       TO PUBLIC;
GRANT ALL ON TABLE TERCEROS_CONTACTOS             TO PUBLIC;
GRANT ALL ON TABLE TERMINALES_NOMBRES             TO PUBLIC;
GRANT ALL ON TABLE TERMINOS_COMERCIO_INT          TO PUBLIC;
GRANT ALL ON TABLE TIPO_CARGA                     TO PUBLIC;
GRANT ALL ON TABLE TIPO_COMPROBANTE               TO PUBLIC;
GRANT ALL ON TABLE TIPO_COTIZANTE                 TO PUBLIC;
GRANT ALL ON TABLE TIPO_CUENTAS                   TO PUBLIC;
GRANT ALL ON TABLE TIPO_DOCUMENTO                 TO PUBLIC;
GRANT ALL ON TABLE TIPO_EMBALAJE                  TO PUBLIC;
GRANT ALL ON TABLE TIPO_GASTOS_IMPORTACION        TO PUBLIC;
GRANT ALL ON TABLE TIPO_ID                        TO PUBLIC;
GRANT ALL ON TABLE TIPO_NOTA_CLIENTE              TO PUBLIC;
GRANT ALL ON TABLE TIPO_NOTADOC                   TO PUBLIC;
GRANT ALL ON TABLE TIPO_PUC                       TO PUBLIC;
GRANT ALL ON TABLE TIPO_VEHICULO                  TO PUBLIC;
GRANT ALL ON TABLE TIPOS_EMBARQUE                 TO PUBLIC;
GRANT ALL ON TABLE TIPOS_MONEDA                   TO PUBLIC;
GRANT ALL ON TABLE CONCILIACION_PAT_DET           TO PUBLIC;
GRANT ALL ON TABLE TIPOS_NOVEDAD                  TO PUBLIC;
GRANT ALL ON TABLE TIQUETE_PASAJERO               TO PUBLIC;
GRANT ALL ON TABLE TRANSPORTADORES_INTERNAC       TO PUBLIC;
GRANT ALL ON TABLE TRASFERENCIAS                  TO PUBLIC;
GRANT ALL ON TABLE TRASFERENCIAS_DETALLE          TO PUBLIC;
GRANT ALL ON TABLE TRASLADOS                      TO PUBLIC;
GRANT ALL ON TABLE TRASLADOS_CAJA                 TO PUBLIC;
GRANT ALL ON TABLE TRASLADOS_CAJA_DET             TO PUBLIC;
GRANT ALL ON TABLE TRASPORTADORES                 TO PUBLIC;
GRANT ALL ON TABLE DETERIORO_CARTERA_ENC          TO PUBLIC;
GRANT ALL ON TABLE UNIDAD_ARTICULO                TO PUBLIC;
GRANT ALL ON TABLE DETERIORO_CARTERA_DET          TO PUBLIC;
GRANT ALL ON TABLE UNIDADES_CARGA                 TO PUBLIC;
GRANT ALL ON TABLE USUARIO                        TO PUBLIC;
GRANT ALL ON TABLE VACACIONES                     TO PUBLIC;
GRANT ALL ON TABLE VACACIONES_DETALLE             TO PUBLIC;
GRANT ALL ON TABLE VACACIONES_DISFRUT             TO PUBLIC;
GRANT ALL ON TABLE VACACIONES_DISFRUT_DET         TO PUBLIC;
GRANT ALL ON TABLE VEHICULO_CARROCERIA            TO PUBLIC;
GRANT ALL ON TABLE VEHICULO_LINEA                 TO PUBLIC;
GRANT ALL ON TABLE VEHICULO_MARCA                 TO PUBLIC;
GRANT ALL ON TABLE VEHICULOS                      TO PUBLIC;
GRANT ALL ON TABLE VENDEDOR_META                  TO PUBLIC;
GRANT ALL ON TABLE VENDEDORES                     TO PUBLIC;
GRANT ALL ON TABLE VENDEDORES_GRUPO               TO PUBLIC;
GRANT ALL ON TABLE VENTAS_MES                     TO PUBLIC;
GRANT ALL ON TABLE ZONAS                          TO PUBLIC;
GRANT ALL ON TABLE AJUSTE_TOTAL                   TO PUBLIC;
GRANT ALL ON TABLE CONSIGNA_TOTAL                 TO PUBLIC;
GRANT ALL ON TABLE CUENTAS_BANCOS                 TO PUBLIC;
GRANT ALL ON TABLE DESENSAMBLE_TOTAL              TO PUBLIC;
GRANT ALL ON TABLE ENSAMBLE_TOTAL                 TO PUBLIC;
GRANT ALL ON TABLE ENTRADA_TOTAL                  TO PUBLIC;
GRANT ALL ON TABLE ORDENINV_TOTAL                 TO PUBLIC;
GRANT ALL ON TABLE RESERVA_TOTAL                  TO PUBLIC;
GRANT ALL ON TABLE SALIDA_TOTAL                   TO PUBLIC;
GRANT ALL ON TABLE TRASLADO_TOTAL                 TO PUBLIC;
GRANT ALL ON TABLE RUTAS_COLEGIOS                 TO PUBLIC;
GRANT ALL ON TABLE CONTRATOS_COLEGIOS             TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_TRANSPORTE           TO PUBLIC;
GRANT ALL ON TABLE RELEVOS_COLEGIOS               TO PUBLIC;
GRANT ALL ON TABLE LIQUIDACION_RUTA_COLEGIO       TO PUBLIC;
GRANT ALL ON TABLE LIQUIDACION_RUTA_DET           TO PUBLIC;
GRANT ALL ON TABLE LIQUIDACION_RUTA_CONC          TO PUBLIC;
GRANT ALL ON TABLE LIQUIDACION_RUTA_EFE           TO PUBLIC;
GRANT ALL ON TABLE RECAUDO                        TO PUBLIC;
GRANT ALL ON TABLE TARIFAS_RETENCION              TO PUBLIC;
GRANT ALL ON TABLE GRUPOS_CIF                     TO PUBLIC;
GRANT ALL ON TABLE ORDEN_SERVICIO                 TO PUBLIC;
GRANT ALL ON TABLE INTERFAZ_PRODUCCION_NIIF       TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_ORDEN_MAQUINA       TO PUBLIC;
GRANT ALL ON TABLE PRODUCCION_ORDEN_OPERARIOS     TO PUBLIC;
GRANT ALL ON TABLE NOTAS_CARTERA_TIPOS            TO PUBLIC;
GRANT ALL ON TABLE REPORT_CHAT                    TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_ENSAMBLE              TO PUBLIC;
GRANT ALL ON TABLE DIASINV_SUGERIDO               TO PUBLIC;
GRANT ALL ON TABLE PROGRAMACION_PAGOS_ENC         TO PUBLIC;
GRANT ALL ON TABLE REPORT_CAMBIOS                 TO PUBLIC;
GRANT ALL ON TABLE FACTURA_EMBALAJE_DET           TO PUBLIC;
GRANT ALL ON TABLE FACTURA_PROFV                  TO PUBLIC;
GRANT ALL ON TABLE REPORT_CAMBIOS_DETALLE         TO PUBLIC;
GRANT ALL ON TABLE FACTURA_PROFV_DETALLE          TO PUBLIC;
GRANT ALL ON TABLE FACTURAS_ALISTAMIENTO          TO PUBLIC;
GRANT ALL ON TABLE REPORT_ENVIOS_DOMICILIO        TO PUBLIC;
GRANT ALL ON TABLE MOTIVO_NO_ENTREGA              TO PUBLIC;
GRANT ALL ON TABLE LISTAPRE_CONFIGURA             TO PUBLIC;
GRANT ALL ON TABLE VACACIONES_COLECTIVAS          TO PUBLIC;
GRANT ALL ON TABLE VACACIONES_COLECTIVAS_DET      TO PUBLIC;
GRANT ALL ON TABLE DIAS_FESTIVOS                  TO PUBLIC;
GRANT ALL ON TABLE DIAS_IVA                       TO PUBLIC;
GRANT ALL ON TABLE RDE_EXEDENTE                   TO PUBLIC;
GRANT ALL ON TABLE LOG_PRESENTACIONES             TO PUBLIC;
GRANT ALL ON TABLE LOG_CLIENTES                   TO PUBLIC;
GRANT ALL ON TABLE LOG_EXISTENCIAS                TO PUBLIC;
GRANT ALL ON TABLE OBSERVACIONES_FEL              TO PUBLIC;
GRANT ALL ON TABLE EMBARGOS                       TO PUBLIC;
GRANT ALL ON TABLE NOMINA_EMBARGOS                TO PUBLIC;
GRANT ALL ON TABLE CERTIFICADOS_RECIBIDOS         TO PUBLIC;
GRANT ALL ON TABLE TIPO_CERTIFICADO               TO PUBLIC;
GRANT ALL ON TABLE BODEGA_GRUPOS                  TO PUBLIC;
GRANT ALL ON TABLE LOG_PRESENTACIONES_Q           TO PUBLIC;
GRANT ALL ON TABLE LOG_EXISTENCIAS_Q              TO PUBLIC;
GRANT ALL ON TABLE TIPO_USUARIO_SALUD             TO PUBLIC;
GRANT ALL ON TABLE MODALIDAD_CONTRATO_SALUD       TO PUBLIC;
GRANT ALL ON TABLE COBERTURA_SALUD                TO PUBLIC;
GRANT ALL ON TABLE ARTICULOS_SUCURSAL             TO PUBLIC;
GRANT ALL ON TABLE RECICAJA_APP                   TO PUBLIC;
GRANT ALL ON TABLE RECICAJA_APP_DET               TO PUBLIC;
GRANT ALL ON TABLE NOTAS_CARTERA_APP              TO PUBLIC;
GRANT ALL ON TABLE NOMINAS_ELECTRONICAS           TO PUBLIC;
GRANT ALL ON TABLE MOTIVO_DEVOLUCION              TO PUBLIC;
GRANT ALL ON TABLE FABRICANTES                    TO PUBLIC;
GRANT ALL ON TABLE CONCEPTOS_NOMELECTRONICA       TO PUBLIC;
GRANT ALL ON TABLE CONFIGURA_NOMELECTRONICA       TO PUBLIC;
GRANT ALL ON TABLE NOMINA_ELECTRONICA             TO PUBLIC;
GRANT ALL ON TABLE CONTEOS_FISICOS                TO PUBLIC;
GRANT ALL ON TABLE AJUSTE_WEB                     TO PUBLIC;
GRANT ALL ON TABLE AJUSTE_WEB_DETALLE             TO PUBLIC;
GRANT ALL ON TABLE CONTEOS_ZONAS                  TO PUBLIC;
GRANT ALL ON TABLE CONVENIOS_CARTERA              TO PUBLIC;
GRANT ALL ON TABLE DOC_INVENTARIO_WEB             TO PUBLIC;
GRANT ALL ON TABLE DOC_INVENTARIO_DET_WEB         TO PUBLIC;
GRANT ALL ON TABLE REPORT_CONEXION                TO PUBLIC;
GRANT ALL ON TABLE REPORT_DOCUMENTOS              TO PUBLIC;
GRANT ALL ON TABLE PRECIOS_FUTUROS                TO PUBLIC;
GRANT ALL ON TABLE PRECIOS_FUTUROS_ARTICULOS      TO PUBLIC;
GRANT ALL ON TABLE REPORT_AGENDA_CLIENTE          TO PUBLIC;
GRANT ALL ON TABLE COSTOS_NEGOCIACION             TO PUBLIC;
GRANT ALL ON TABLE REPORT_AGENDA_PROVEEDOR        TO PUBLIC;


GRANT EXECUTE ON PROCEDURE ABONOS_DOCUMENTO_CARTERA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AFECTA_INVENTARIO_FACTURAS     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ABONOS_DOCUMENTO_CXPAGAR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_COSTO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_ACTIVO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_ARTICULO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_CENTRO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_CENTRO_TERCERO TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_CUENTA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_TERCERO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALIZA_PUNTOS_ACUMULADOS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACUMULA_PUNTOS_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AKTIVIA_CARTERA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AKTIVIA_CLIENTES               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AKTIVIA_INVENTARIO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AKTIVIA_PRODUCTOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AKTIVIA_VENDEDORES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ALERTAS_CONTRATO_EMPL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCUMENTOS_INTERFAZ_SIN_CUENTASTO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_VENTAS_VENDEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_INVENTARIO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_VACACIONES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRAR_FACTURAS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE APLICACIONCL_SIN_CONTABILIDAD  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_MENSAJES_USUARIOS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INACTIVOS_EXISTENCIA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIERRE_FACTURACION_VEND        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AGREGA_ENTIDAD_CONCEPTOEMPL    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE APLICACIONPR_SIN_CONTABILIDAD  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARCHIVO_BANCO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRA_DESCUADRADOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_REVALID_CLIENTES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_REVALID_PRODUCTOS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_REVALID_VENTAS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_COSTO_PLANPROD         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_COSTO_PRODENT          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_CUENTA_BANCO_CONTA     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_EXIST_PROD_CONS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_MOV_CAJA_RC            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_MOV_CLIENTE_RC         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ART_INACTIVOS_CON_EXISTENCIA   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARTICULOS_SIN_CONTAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ASIGNA_COBRADOR                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ASIGNA_PRECIOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ASIGNA_RUTERO_FAC              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_ARTICULO_MES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CENTRO_DESDE_HASTA    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CENTRO_INI_FIN        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CENTRO_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CUENTA_INI_FIN        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CUENTA_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIGITO_CHEQUEO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_DESDE_HASTA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CODIGO_BARRAS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_TERCERO_DESDE_HASTA   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_TERCERO_INI_FIN       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_TERCERO_MES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_VENTAS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_TIVA                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESTAMOS_PENDIENTES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_PREFIJO_RR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_CLIENTES_RR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_NOTAS_IMPR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_BUSCADOC                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_USUARIO_CORREO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_RUTEROS_CONDUCTOR         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_ANUAL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_ARTICULO_MES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CENTRO_MES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_COMPARATIVO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_DISMINUCION_VENTAS_PROD    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CON_CENTROS_MES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROMEDIO_Y_ULTIMO_NIIF   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROMEDIO_NIIF            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROMEDIO_UNIDAD_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CON_TERCEROS_MES       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_INICIAL                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_ANTICIPOS_CLI         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_MES                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_MES_DINAMIC            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_PRUEBA_ACUMULADO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_TERCERO_ANO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CENTRO_MES_N       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CENTRO_MES_N           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CENTRO_MES_N          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_TERCERO_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BONOS_DISPONIBLES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRE_CONTABIL_FACTURA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCA_ID_DOC                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESTAMOS_EMPLEADO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCA_ID_DOC_CARTERA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_LOTES2                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCA_ID_DOC_CXPAGAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCAR_COMPROMISOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCAR_DEVOLCHEQ               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_ANTICIPOS_PRV         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_CAMPANAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_CLIENTES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_COMPROMISOS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_COMPROMISOS_CLI       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_DOCS_PRODUCCION       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_EVENTOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_EVENTOS_CLI           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_NOTASDOC              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_PENDIENTES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_REMESAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_PRODUCCION            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXPORTA_FACTURAS_ASOB          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_COSTOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTADO_COSTOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_PROSPECTOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_REMISIONES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_IMPORTACIONES         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_MES                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALC_SALDOSINI_NOMINA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_COMISIONES_NOMINA      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_CRUCE_PROVISIONAL      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_PORCPRECIO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_PRECIOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULE_DV                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_CLIENTE                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_CTAS_ARTI               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_CTAS_CLIENTES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_CTAS_PROVEEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_AJUSTEINV            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_AJUSTESINF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ANTICLIE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ANTIPROV             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_APLICLIE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_APLIPROV             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CAMBCOSTO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CAMBDOCU             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CHEQUE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CIERANUAL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CIERTERC             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_COMPRAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_COMPROBA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONCILIAB            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONFIRMDEPOS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONSIGNA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONSIGNATAR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONSOLFP             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONSUMO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_COTICOMP             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_COTIZACI             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CUENTA_BANCO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DESENSAMBLE          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DEV_CHEQUES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DEVOLCLIE            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DEVOLPROV            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DISFVACAC            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_EGRESO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ENSAMBLE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ENTRADA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ENTRSALEMPL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ENVIO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_EVENTO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_FACTCONT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_FACTPER              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_FACTURA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_HORARIOEMPL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTERBANCO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTERCAJA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTERCARTERA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTERCMP             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTERCOMPRA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTERCXPAGAR         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTERVTA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_INTINVENTARIO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOMINA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOMINA_PROV          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOMINACOMISIONES     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOTA_CR_BANCO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOTA_DB_BANCO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOTACRCLIE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOTACRPROV           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOTADBCLIE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOTADBPROV           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_NOVEDAD              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ORDEMBARQUE          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ORDENCOMP            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ORDENMCIA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ORDENPROD            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PAGO_NOMINA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PEDIDO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PENDIENTE            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PLANPROD             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PLANTILLA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PRESTAMOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PRODDEV              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PRODENT              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PRODSAL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_RECICAJA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_RECIPROV             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_REDIPTOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_REDPTOSV             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_REMICLIE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_REMIPROV             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_RESERVA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_RETIRO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_REVPRECIO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_RUTERO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_SALIDA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_SOLIMP               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_TRANSFER             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_TRASLACAJA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_TRASLADO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_IDNOTADOC               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIO_ANO_CONTA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIO_CODIGO_ARTICULO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIO_PRECIOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIOS_PATRIMONIO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LEE_CONFIGURACION_REPORT       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_CRONOLOGICO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIOS_SITUACION              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CANTIDAD_POR_FACTOR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PENDIENTES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_FALTANTES               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_ENVIOSF_CORREO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_RESULTADCORREO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CARTERA_CLIENTE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DATOS_COMPANIA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_DIFERENCIA_CAMBIO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOMINA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOMINA_EMPLEADO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CEROS_ANCHO_FIJO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CERTIFICA_LABORAL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CUENTA_BANCO_CONF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_BANCO_CONF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESTE_SALDO_BANCO_CONF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CERTIFICADOS_RETENCION         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULE_CESANTIA_LIQ           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ACTIVO_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_TICKET_IMPR             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ARTICULO_NIIF            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CENTRO_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVTOS_CENTRO_TERCERO_MES_N    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CENTRO_TERCERO_NIIF      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CUENTA_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CREAR_CLIENTE                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CONSNOMINA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CERTIFICADOS_RETENCION_LABORAL TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEA_VENCIMIENTOS_CARGOS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_COSTOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_NOTAS_EVENTO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_INVENTARIO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_LOTES                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AJUSTA_CANT_PEDIDO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_MOVIMIENTO_CLIENTES    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_VENTAS_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CARTERA_PUNTO_DIA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_DOCUMENTOS_PAGO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_ANUAL_CENTROS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_MOVIMIENTO_CXPAGAR     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_PUNTOS_VENDEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_BANCOS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_CAJAS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_CONTA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CAMPANAS                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_IDREEMFAC               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_DOC_CARTERA     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_DOC_CXPAGAR     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_IMPORTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_STANDS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUES_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIERRE_DIARIO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIERRE_FACTURACION             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ARQUEO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_LIQRUTA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_ENTRADAS_COSTO_CERO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLASIFICA_INVENTARIO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_SIN_REGISTRO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COBRADOR_NOTAS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECLASIFICA_DEVDEC1818         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_ANO1           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMISIONES_ARTICULO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_ARTICULO_ANO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECUPERA_FACTURAS_VEND         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMISIONES_CALLCENTER          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMISIONES_COBRO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_PRMINIMO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMISIONES_DOCUMENTO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPLETA_NUMERO_COMPROBANTE    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_CENTROS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_MOVIMIENTO_ARTICULO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPLETA_CEROS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPONE_FECHA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPONE_FECHA_CONTA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_ARTICULO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_ARTICULO_DETALLE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_ARTICULO_MES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_PROVEEDOR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_PROVEEDOR_ANO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_PROVEEDOR_MES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_SIN_INVENTARIO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPROBANTES_ACTIVO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPROBANTES_DIARIO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPROBANTES_NEGATIVOS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPROBANTES_TERCERO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_BANCO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_PEDIDOS_VEND              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LISTAS_ARTICULO_WEB            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_BANCO_ACT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_BANCO_CONTA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_CAJA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_CARTERA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CAMBCOSTO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_CARTERA_DET           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_MOV_CLIENTE_APL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_PERIODO_PAGO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_COMPRAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_COSTOVENTAS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRAR_PEDIDO_WEB              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCUMENTOS_IMPORTACION         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAF                            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RENGLON_NOVEDAD_APORTES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CAMBCOSTO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_CXPAGAR               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_CXPAGAR_DET           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_DEVCOMPRAS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_DEVVENTAS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_INVENTARIO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_INVENTARIO_DET        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_VENTAS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONFIRMA_RUTERO_FAC            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONS_SALDOSINI_NOMINA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSECUTIVOS_CONTA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSIGNA_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDA_ARTICULOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDA_CONC_NOMINA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDA_CONC_NOMINA_PROV     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDA_ITEMS_AJUSTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_MOVBANCO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_IMPORTACIONES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDE_AJUSTES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPLETA_CEROS8                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MANIFIESTOS_CONDUCTOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOMINA_1_EMPLEADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INACTIVA_ARTICULOS_CERO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PEDIDOS_X_ORDENAR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_AUTOCART             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDE_PENDIENTES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDE_PRODUCCION           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_ARTICULOS_PRECIOS     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_ARTICULOS_VTAS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_BALANCE_MES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_CLIENTES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_PRESUPUESTO_MES       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_PUNTOS_CLIENTE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_PUNTOS_VENDEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSUMO_HISTORICO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSUMO_PRECIOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_AJUSTE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_APLICACL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRECIOS_RIMAR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INFORME_DIARIO_VENTAS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INFORME_DIARIO_VENTAS_FP       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTIVO_VALOR                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMA_DEPRECIACION_UNIDADES   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTIVO_VALOR_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_APLICAPR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FACTURAS_MES               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CHEQUE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RENGLON_VS_APORTES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CONSIGNA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_PRESTAMOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CONSIGNA_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CONSIGNATAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CONSIGNATAR_NIIF      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DESENSAMBLE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCHEQ             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_SIN_FACTURAS_MES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE KARDEX_ARTICULO_MES_N          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCOMP             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_EGRESO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EDITA_CLIENTE_MOVIL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_ENSAMBLE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INCAPACIDAD_TOTAL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_ENTRADA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PLANILLA_NOMINA_HORAS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP_IVA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_FACTOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_IVA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_MANIFIESTO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOMINA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ASIGNE_FACTURA_ENTREGA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTREGA_SIGUIENTE_ITEM         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRBC              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRBC_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRCL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONDUCTORES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_BARRAS_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRPR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DINERO_DISPONIBLE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE KARDEX_INVENTARIO_MES_N        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBBC              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBCL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBPR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PAGONOMI              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ASIGNE_BOLETAS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_SORTEO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PLANILLA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ARQUEO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODUCCION            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODUCCION_DEV        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_COSTOS_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIA_BODEGA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PEDIDOS_WEB_POR_CONFIRMAR      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INFORME_DIARIO_VENTAS_TERM     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PERFILES_EMPLEADO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODUCCION_ENT        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODUCCION_SAL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RECICAJA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRECIO_UNIDAD                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_PAT_DETALLE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_COSTO_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_APERTURA_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_SUCURSALES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RECIPROV              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COPIA_CUENTAS_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RECIPROV_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_NOMINA_HORASEXTRA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_FINAL_DET              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_VACACION             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMESA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CLIENTE_FAC              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMINA_SALARIOS_UGPP           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EMPLEADO_ACTIVO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RETIRO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RUTERO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_CONTA_NIIF      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_SALIDA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_INDEMNIZACION          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_TRASLACAJA_NIIF       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_TRASCUENTA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BASE_CUENTA_MES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_INVENTARIO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_COSTOS_NIIF            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_TRASLACAJA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DETALLE_CERTIFICADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_TRASLAMERCANCIA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILICE_COMP_SIMPLIFICADO  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILICE_COSTO_VENTAS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CENTRO_MES_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILIZA_PENDIENTE          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTACTOS_CLIENTE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTADO_MVERDE                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTADO_MVERDE2                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTADOS_SIN_RECIBO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COPIA_INTERFAZ_BANCOS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COPIA_LISTA_PRECIOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CORREOS_TERCERO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_EN_VENTAS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_EN_VENTAS_CONTADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROMEDIO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROMEDIO_UNIDAD          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROMEDIO_Y_ULTIMO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROMEDIO_Y_ULTIMO_UNIDAD TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_PROVEEDOR                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTOS_PROVEEDOR_TRASLADO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CREE_CUENTA_PUC                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CRONOLOGICO_CONTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_LABORADOS_SINV            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOMINA_VACACIONES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_TERCEROS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCERO_FECHA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CRUCES_DOCUMENTO_DETALLE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CAMPANA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_PEDIDOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CRUCES_DOCUMENTOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_CAJA_EGRESOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_UNA_CAJA_EGRESOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CRUCES_DOCUMENTOS_CAJA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CANCELE_FACTURA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_CAJA                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ARTICULOS_MOVIL_OFFLINE   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_CAJA_ABONOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE UNIDADES_OFFLINE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRE_APERTURA_NIIF            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_ARTICULO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LISTA_PRECIOS_OFFLINE          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_CAJA_DETALLE            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_CAJA_FPAGO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_COMPROBANTES_CONTABLES  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_UNA_CAJA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_UNA_CAJA_DETALLE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_UNA_CAJA_ABONOS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_UNA_CAJA_FPAGO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTA_AFECTABLE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTA_INTERFAZ                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTAS_ARTICULOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUPO_DISPONIBLE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_CAMBART              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CXPAGAR_PROVEEDOR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_EVENTO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DESCARGA_REMIPROV_FALTANTE     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOM1EMPLEADO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOM2EMPLEADO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DESCARGA_REMISION_FALTANTE     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DESCUENTOS_PEDIDO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DESENSAMBLES_SIN_CONTABILIDAD  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_SALIDA_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_COMPRAS_ARTICULO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_COMPRAS_PROVEEDOR      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_DEVOLUCIONES_POS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_VENTAS_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_VENTAS_ARTICULO_VEND   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_VENTAS_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_VENTAS_VENDEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEV_INVENTARIO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVCOMPRA_SIN_CONTABILIDAD     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLCOMP_SIN_INVENTARIO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLUCIONES_SIN_CONTABILIDAD  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PEDIDOS_POR_ENTREGAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLUCIONES_SIN_INVENTARIO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIA_FECHA                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_ENTRE_NOMINA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_LABORADOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_MES                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOMINA1                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CENTRO_TERCERO_MES_N   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_ARTICULOS_MOVILC      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_IVA16_FACTURA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCEROS_FECHA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_NOMINA2                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIF_MOVBANCO_CONCILIACION      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_TERCERO_MES_N         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIFERENCIAS_CONTEO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIGITOS_NIVEL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_FACTURAS16_FECHA     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DISPONIBILIDAD_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DISPONIBILIDAD_TOTAL_ARTICULO  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCCAJA_SIN_ENTRADA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCCOMPRA_X_IMPORT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXPORTAR_RUTERO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCERO_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCCOMPRA_X_PROVEEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCUMENTOS_SIN_CONTABILIZAR    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPRAS_GRUPO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_VACACIONES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_LABORADOS_LIQ             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CREA_BARRAS                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_DESDE_HASTA_NIIF      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_RECAUDO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCVENTAS_X_CLIENTE            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DV                             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BODEGA_FACTURACION             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBBC_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EGRESOS_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENSAMBLES_SIN_CONTABILIDAD     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_RUTERO_DET                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_DESCUENTO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTRADAS_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ERROR                          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ES_AFECTABLE                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CIUDAD_VENDEDOR         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ESTADISTICA_VENTAS_VENDEDOR_ANOTO PUBLIC;
GRANT EXECUTE ON PROCEDURE ESTADISTICA_VENTAS_VENDEDOR_MESTO PUBLIC;
GRANT EXECUTE ON PROCEDURE ESTADO_FLUJO_EFECTIVO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTE_CENTRO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTE_CUENTA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTE_TERCERO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_BAJO_MINIMO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PEDWEB               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_PEDIDO_WEB               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_COMPRAS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRECIOS_WEB                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_ORDENES_COMPRA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_GASTOIMP             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_WEB                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_DESDE_HASTA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMBRE_ASCII                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALOR_INICIAL_INVENTARIO_N     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE KARDEX_DESDE_HASTA_N           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_MINYMAX            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_SIN_AJUSTAR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_32                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_SOBRE_MAXIMO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECUPERA_PEDIDOS_VEND          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_PEDIDO_WEB               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_PEDIDO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_UNIDAD             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VER_ARTICULOS_PEDWEB           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FALTANTE_CORTE                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXPORTA_FACTURAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_DESCUENTO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTCOMP_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTCOMP_SIN_INVENTARIO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTOR_UNIDAD_CANT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_UN_RECAUDO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULE_FACTURAS_MAL_TOTAL   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTOR_UNIDAD_PRE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAR_CONCEPTOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIQUIDACION_IMPORTACION        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCA_ID_DOC_CXPAGAR_P         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_TRASCUENTA_NIIF       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONCEPTOS_NOMINA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_MAL_TOTAL             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_MES_NIT               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_POR_ENTREGAR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_RUTERO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRECIO_CANTIDAD                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_SIN_INVENTARIO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_SIN_MOV               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INACTIVAR_ACTUALIZACION_BALANCETO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTIVAR_ACTUALIZACION_BALANCE  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AJUSTES_SIN_CONTABILDAD_NIIF   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DESENSAMBLES_SIN_CONTABIL_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FALTANTE                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_ACUM_CUENTA_MES     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_ACTIVO_NIIF    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_ARTICULO_NIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FALTANTE_DOCUMENTO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FALTANTES_COMPRAS_ARTICULO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ERRORINT                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DECRETO1818                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_AGENCIA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_FORMA_PAGO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FALTANTES_VENTAS_ARTICULO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_A_CONTA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_DESDE_CONTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_FINAL_PERIODO_PAGO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_INICIAL_PERIODO_PAGO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_Y_NUMERO_CONTA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHAS_ANTERIORES_LOTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FIN_DE_MES                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FORM_INTEGRADO_ELECTRONICO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FORM_INTEGRADO_ELECTRONICO_ARP TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FORMULA_PRECIOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE HISTORIA_MENSAJES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE HISTORICO_CARTERA_CLIENTE      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE HISTORICO_EMPLEADO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_COMPROBANTE_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_APORTES                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_EMPLEADO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IDS_CORTE                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_AJUSTE                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ANTICLIE                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ANTIPROV                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_APLICLIE                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_APLIPROV                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_APORTES                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ARTICULO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CAMBDOCU                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CERTRETE                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_COMPROBANTE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CONCILIACIONB             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CONSIGNA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CONSIGNATAR               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CONTABILIZACION           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_COTIPROV                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_COTIZACION                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_MUNICIPIOS_BIT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CRUCES                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_TIPONEGOCIO_BIT            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETERIORO_CARTERA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_DESENSAMBLE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_DEVOLPROV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_DEVOLUCION                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_EGRESO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ENSAMBLE                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ENTRADA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_FACTCOMP                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_FACTPRO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_FACTURA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_ARTICULO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXPORTAR_CLIENTES_MEDICOXRAVEN TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_FORMAPAGO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_LIQUIDACION          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_LIQUIDACION               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_ARTICULOI          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_NOTACRCL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_NOTACRPR                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_NOTADBCL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_NOTADBPR                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_CUENTA_BANCO_CONTA      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_CENT_TERC_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_CUENTA_NIIF    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_TERCERO_NIIF   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTE_CUENTA_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ORDENCMP                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DEPRECIA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_VENTAS_CIUDAD          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIERRE_FORMAPAGO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ORDENINV                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PEDIDO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PENDIENTE                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VEHICULOS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DOCUMENTOS_VEHICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_TRANS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_TRANS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PLANILLA_NOMINA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PLANILLA_NOMINA_PROV      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PLANPROD                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PLANPROD_CONS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PLANPROD_ENT              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PLANREMESA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PRODUCCION                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PRODUCCION_ENT            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PRODUCCION_ENTRADA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PRODUCCION_MONTAJE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_RECICAJA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_RECICJPAGO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_RECIPROV                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_REDENCION                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_REMIPROV                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_TERCERO_DESDE_HASTATO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAR_REMISIONES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_CLIENTE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXPORTA_FACTURAS_DET           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CON_CENTROS_MES_N      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_TERCERO_MES_NIIF    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_COMPARATIVO_NIIF       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CERRAR_IMPORTACION             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTA_MAL_AFECTABLE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_LIQRUTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_RECAUDO_RUTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIFERENCIAS_ARTICULOS_BD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_REMISION                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MANIFIESTOS_VEHICULO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_LIQUIDACION               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_RESERVA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_REVPRECIOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_BIT_TIPONEGOCIO_V3         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_BIT_SKU_V3                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_BIT_CLIENTES_V3            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_BIT_VENTASDET_V3           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_BIT_CLIENTES_V2            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_MILISTAPP_INVENTARIO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCTRANSP_X_CLIENTE            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_MARCA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_PEDIDO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANTICIPOS_PEDIDO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCA_DOCS_ALISTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PEDIDOS_DES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PEDIDOS_DCG             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_VENTAS_NOTA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_CERTICA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECONSTRUYE_EVENTOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALARIO_PROMEDIO_LIQ           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RETENCIONES_QUE_NOS_PRACTICARONTO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM16472                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22763_N                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22763                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTCOMP_MAL_TOTAL             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_CANT_REMIPROV          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INSERTE_RUTERO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AGREGA_FACTURA_RUTERO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONFIRMACION_ENTREGA_FACTURA   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLUCION_FACTURA_RUTERO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EMBALAJES_FACTURA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ASIGNAR_TRANSPORTE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FINALIZAR_EMBALAJE_FACTURA     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NUMERO_FORMATEADO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_INVENTARIO_PEDIDO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TOTAL_INVENTARIOC        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARTICULOS_API                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_EMBALAJE_FACTF            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARTICULOS_OK                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_IVAYTOTAL_FAC          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_DOC_TERCERO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BODEGAS_FAC                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_ITEM_COTIZACION_APP   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VAL_ARTICULO_REPETIDO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_VENDEDORES_WEB            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDA_ACCESO_USUARIO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CORDENADAS_WEB            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_RUTA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESENTACIONES_Q_OK            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESENTACIONES_QUQO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_QUQO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_Q_OK               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_IVA_DEVOLUCION       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_VACACIONES2            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_RUTERO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_DATOS_CLIENTES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_VACACOL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_DECRETO551JL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_DECRETO551          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INACTIVAR_CLIENTES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INACTIVAR_ARTICULOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_FACTELECTRONICA22       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PAGO_FACTURAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10047                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RDE_DAYPARKING                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RDE_DAYPARKING2                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RDE_DAYPARKING3                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_ITEM_DIAIVA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_DIASINIVA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_CONCEPTO_MM2276        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_CONCEPTO_MM2276N       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RDE_DAYPARKING4                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMO_COSTO_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMICLIE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BASE_CUENTA_MES_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_NETO_CUENTA_MES_N   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_SALIDA                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_TRASFERENCIA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_TRASLACAJA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_TRASLADOBCO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_VACACIONES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BODEGA_FACTURACION_ALTERNA     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPUESTOS_CLIENTE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_FACTURA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPUESTOS_COMPRAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CODIGOS_BARRAS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_ARTICULOS_WEB         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_MENOS_RESERVA      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PEDIDOS_ENTREGA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_EXISTENCIAS_WEB       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REDONDEE_PRECIO_LISTA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COLA_FUNCIONES                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPUESTOS_PROVEEDOR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPUESTOS_VENTAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INCREMENTE_NROCOPIA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INSERTE_SALDO_INICIAL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INVENTARIO_FACTCOMP_SIN_REMI   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INVENTARIO_FAMILIA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INVENTARIO_Y_BALANCE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE KARDEX_ARTICULO_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE KARDEX_DESDE_HASTA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE KARDEX_INVENTARIO_MES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LEE_CONFIGURACION              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIBRO_DIARIO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIBRO_DIARIO_CUENTA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIQUIDA_VACACIONES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_INICIAL_DET            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIQUIDACION_APORTES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_PUNTOS_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIQUIDACION_EMPLEADO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_SALDO_CENTRO_NIIF    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTE_MOVIL             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LISTA_LOTES                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_PRESTAMO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LISTAS_ARTICULO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MAX_NIVEL                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MAXIMO_ARTICULO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MAYOR_SALDO_LOTE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MAYOR_Y_BALANCE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MEDIOS_MAGNETICOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MEDIOS_MAGNETICOS_SHD          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MEDIOS_MAGNETICOS2             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MERCANCIA_EN_TRANSITO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MES_FECHA                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MINIMO_ARTICULO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_SUCURSAL_MED          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1001                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1001_8                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1002                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1003                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1005                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10057                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1006                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10067                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1007                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUMA_DESCUENTOS_FINANCIEROS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10078                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1008                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1009                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1011                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIFERENCIAS_TERCEROS_BD        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1012                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_2                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCAR_CHEQUES                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_4                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_6                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOV_DETALLE_BANCOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOV_DETALLE_CAJAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVARTI_CANTIDADES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVBANCO_NO_CONCILIADOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVER_FORMATO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_ARTICULO_ANULADO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_ARTICULO_DESDE_HASTATO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_ARTICULO_MES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_ARTICULOC_MES       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_BANCO_MES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CAJA_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CARTERA_DESDE_HASTA TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CARTERA_MES         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CENTRO_MES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CUENTA_DESDE_HASTA  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CUENTA_MES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CXPAGAR_DESDE_HASTA TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CXPAGAR_MES         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_INVENTARIO_MES      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_COSTO_PROV           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_NETO_CUENTA_MES     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_NO_AFECTABLE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_TERCERO_MES         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_TOTAL_ARTICULO_MES  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_ARTICULOC_MES      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CENTRO_MES         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CUENTA_DESDE_HASTA TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CUENTA_MES         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_TERCERO_MES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVLOTES_DESDE_HASTA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMBRE_COMPANIA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMBRES_GRUPOS_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMBRES_GRUPOS_INVENTARIO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOTACRCL_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOTACRPR_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOTADBCL_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOTADBPR_SIN_CONTABILIDAD      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOTASCRBC_SIN_CONTABILIDAD     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOTASDBBC_SIN_CONTABILIDAD     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOVEDADESXPERIODO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NRO_COPIA                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NROBANCO_REF_EGRESOS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NUM_ENT                        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NUMERO_CONCILIACION            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDEN_PROVEEDOR                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUMA_APERTURA_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDEN_SUGERIDA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDEN_SUGERIDA_BOD             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDENA_MOVARTICULO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDENES_ARTICULO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDENES_ARTICULO_FECHA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PADRE                          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PAGO_NOMINA_XEMPL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PAGO_NOMINA_XEMPL_DETA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PENDIENTES_X_CLIENTE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PERIODO_NOM_FECHA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PLANILLA_NOMINA_NOVEDADES      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PORCENTAJE                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE POS                            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRECIOS_UNIDAD                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRECIOS_Y_EXISTENCIA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESUPUESTO_MES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRODUCCION_SUGERIDA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PROMEDIO_PRODUCCION_ARTICULO   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PROMEDIO_SALIDAS_ARTICULO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PROMEDIO_TOTAL_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PROVEEDORES_SIN_REGISTRO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PUNTOS_VENDEDOR_FECHAS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RANGO_CLIENTES                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_FALTANTES_VENTAS     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_FALTANTES_VENTAS2    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_IDREF                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_PUNTOS_CLIENTE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULO_COMISIONES_VENTAS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULO_DEV_REMISION         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NUMERO_DOCUMENTO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECCONTADO_MVERDE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTA_INTERFAZ_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECIBOS_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECONTABILICE_COSTOS_VENTAS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECUPERA_NUMERO_CHEQUE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_ENTRADA_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_TRASMERC_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_AJUSTE_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECUPERACION_CARTERA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CAMBCOSTO_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REDONDEE                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REDONDEE_NOTAS_PROVEEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRA_RECIBOS_CONTADO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_APLICACIONES_CLIENTES TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_APLICACIONES_PROVEEDORTO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_COINCIDENCIAS_CONTEO  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_REGIAUTO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REMISIONES_COSTO_CERO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ABC_INVENTARIO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_AJUSTES_ARTICULO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ANALISIS_CARTERA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FALTANTES_COMPRAS_ARTICULOI    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_DISMINUCION_VENTAS_CLI     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ANALISIS_CXPAGAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_APLICACLI                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_APLICAPROV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_INVENTARIO_GRUPO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_INVENTARIO_MARCA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ARTICULO_BARRAS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ARTICULOS_CLIENTE          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ARTICULOS_CONTABIL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ARTICULOS_PROVEEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ARTICULOS_VENDEDOR         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_AUDITORIA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_AUSENTISMO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_UTILIDAD_VENTAS_SUBG       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CARTERA_CLIENTES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CARTERA_CONSOLIDADA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CARTERA_NOTAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CLIENTES                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CLIENTES_CRM               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CLIENTES_ULTVENTA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALIZA_BASES_RETENCION      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_ARTICULO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_PROVEEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_PROVEEDOR_ANO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_ARTICULO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_BANCOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_CAJA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_CAJA_ART      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECONTABILICE_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_CAJA_DET      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_CARTERA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_CMP           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_CXPAGAR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_FAC           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_INV           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONCEP_XPAGAR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPARTE_SALIDA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_BANCOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_CAJA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_CARTERA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_CMP           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_CXPAGAR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_EGRESOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_FAC           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_INV           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSIGNACIONES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CRM_CLIENTES               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CRM_EVENTOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_FECNOMINA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CRUCES_DOCUMENTO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CXPAGAR_CONSOLIDADAS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CXPAGAR_PROVEEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORTE_IMPORTACIONES          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_RUTEROS                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_ITEM_FACTURA_WEB      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DISPONIBILIDAD             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_PROVEEDORI         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DOCUMENTOS_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DOCUMENTOS_ENCAJA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DOCUMENTOS_PROVEEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_EGRESOS                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_EMPLEADOS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ENSAMBLES                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ENTREGA_FACTURAS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ESTADO_CUENTA_BANCO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_EXISTENCIAS_PRECIOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAR_REMISION              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PLANILLA_INVENTARIO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FALTANTES_CLIENTES         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FALTANTES_COMPRA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FALTANTES_PROVEEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CORTE_CXPAGAR                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FALTANTES_VENDEDOR         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_EN_VENTAS_CONTADO_NIT    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_NIT  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTADO_MVERDE_NIT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_TOTAL_DOCVENTA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_IVA_FACTURA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_FACTURAS_FECHA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_TOTAL_REEMFAC        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FALTANTES_VENTA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_GRUPOS_VENDEDOR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_HISTOEMPL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_HOJADEVIDA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_KARDEX_ARTICULO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTA_AFECTABLE_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_CUENTA_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCERO_MES_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_TERCERO_MES_NIIF   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESULTADO_ANUAL                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_TERCERO_MES_NIIF       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_LISTA_PRECIOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_NOMINA_NOVEDADES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_LIQRUTAC                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_METAS_VENTAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_MOVCAJA_DOCUMENTOS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_MOVIMIENTO_ARTICULO_DOC    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_MOVIMIENTO_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_MOVIMIENTO_DIARIO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_MOVIMIENTO_PROVEEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_MOVIMIENTO_X_ARTICULO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRESUPUESTO_GRUPOS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRODUCCION                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRODUCTOS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PROVEEDOR_X_ARTICULO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_RETENCION_CLIENTE          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_RETENCION_PROVEEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_TERCEROS                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_UTILIDAD_CLIENTE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_UTILIDAD_VENDEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_UTILIDAD_VENTAS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENDEDORES                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_ARTICULO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_CANAL               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_CLIENTE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_CLIENTE_ANO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_VENDEDOR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_VENDEDOR_GRUPO      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORTE_FAMILIA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORTE_FAMILIA_CAB            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORTE_PUNTOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESERVAS_ARTICULO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CEROS_AJUSTE                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_EMPLEADOS_CONCEPTOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMIN_MES                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ITEM_FACTURA_ALISTA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_ITEM_PEDIDO_APP       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CRM_COMPROMISOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_CADENA_FALTANTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MONTO_MENSUAL_CONCEPTO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REENVIO_NOMIN_MES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FECHA_NOMINA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMINA_MENSUAL                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMAGENES_ARTICULO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_RECIBO_PROV           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_ITEM_RECIBO_PROV      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_RECIBO_PROV              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DETALLE_FACTURA_NETO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GENERE_PENDIENTE_ENTREGA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ASOCIADOS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BODEGAS_INV                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DOCINVWEB            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_DOCUMENTO_INV_WEB        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_TERCERO_QUQO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_NEG_PROMEDIO_Y_ULTIMO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_NEG_VENTAS_ITEM          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VER_ARTICULOS_DOCWEB           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_CONSULTA_PREFIJO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_TRAE_VENTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CARTERA_CLIENTE_REM            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_ITEM_FACTURA_APP      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILIZA_FACTURA_APP        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_RECIBO_APP            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_ITEM_RECIBO_APP       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_RECIBO_APP               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILIZA_RECIBO_APP         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_NOTA_CARTERA_APP      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INSERTA_DOCUMENTO_FACTURA      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_COMPROBANTE_APP       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_ITEM_COMPROBANTE_APP  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESERVAS_ARTICULO_FECHA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESTE_EXISTENCIA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESTE_SALDO_BANCO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESTE_SALDO_CAJA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESTE_SALDO_EFECTIVO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_CAJA_TX                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CUENTA_MES_NIIF       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CUENTA_MES_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_PADRE_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_FINAL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_CUENTA_NIIF_C           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_EMPAQUE                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AJUSTES_APERTURA_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CUENTA_MES_NIIF    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_ENSAMBLE_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_DIA                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_PUNTOS_TX              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_SALDOS_BANCO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_SALDOS_CAJA            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_VENTAS_DIA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_VENTAS_TX              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RETIROS_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REVERSA_TRASLADO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REVERSE_RETENCIONES_EGRESOS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REVISA_PRECIOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REVISA_PRECIOS_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RUTERO_CONSOLIDADO_ARTICULO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RUTERO_FACTURA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_INVENTARIO_PROV            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_INVENTARIO_BAJAROT         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALARIO_BASE_EMPLEADO          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_BALANCE_MES_NIIF      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIACION_PATRIMONIAL       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_LIQRUTAC_CONC             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_LIQRUTAC_EFE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENDEDORES_BIT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1001_9                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALARIO_PROMEDIO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ACTIVO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALARIO_PROMEDIO_SIN_AUX       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALARIO_PROMEDIO_VACACIONES    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ACTIVO_MES               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ARTICULO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ARTICULO_MES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CENTRO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CENTRO_MES               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CENTRO_TERCERO           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CLIENTE                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CLIENTE_SUCURSAL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CUENTA                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CUENTA_BANCO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CUENTA_MES               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_CUENTAF                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_DOC_CARTERA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_DOC_CXPAGAR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_EN_CAJA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_EN_EFECTIVO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_FINAL_CAJA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_FINAL_CUENTA_BANCO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INICIAL_INVENTARIO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INICIAL_PROVEEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INICIAL_TOTAL_INV        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_INVENTARIO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_LOTE                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_LOTE_FECHA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_PROVEEDOR                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCERO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TERCERO_MES              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TOTAL_INVENTARIO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDOS_ARTICULO_CUENTA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDOS_FACTURA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALIDAS_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SELECCIONE_LOTE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGIERE_METAS_VENTAS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGIERE_PRECIO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_EXISTENCIA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_BANCO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_CAJA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_CUENTA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUME_SALDO_EFECTIVO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TARIFAS_ENSAMBLE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_DOC_COMPRA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_DOC_IMPORT               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_DOC_VENTAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_PAGOS_TERCERO_ANO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASCUENTAS_SIN_CONTABILIDAD   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_ITEM              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22761                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASFERENCIAS_SIN_CONTABILIDAD TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_REMESA                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASLACAJAS_SIN_CONTABILIDAD   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMO_COMPROMISO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMO_COSTO                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ULTIMO_EVENTO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE UNIDADES                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE USUARIOS_MENSAJE               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_TERCERO_DESDE_HASTA_N TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AUXILIAR_CENTRO_DESDE_HASTA_N  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE UTILIDAD_VENTAS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDA_CUENTAS_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_ARTICULO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_BONO                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_CUENTA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_CUENTA_C                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_ESTRUCTURA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_EXISTENCIA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_NIVEL                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_PADRE                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALOR_INICIAL_INVENTARIO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENCIDO_CLIENTE                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ANUALES_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ANUALES_CLIENTE         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ANUALES_VENDEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_ANO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_CLIENTE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_ARTICULO_VENDEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CADENA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE_ANO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE_MES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_CLIENTE_VENDEDOR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_POR_HORA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_POR_HORA_ARTICULO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_VENDEDOR                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_VENDEDOR_ANO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VENTAS_VENDEDOR_MES            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VERIFIQUE_CUENTA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_DIFERENCIAS_CONTEO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRA_CONTABIL_DOCUMENTOS      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_LOTES_FECHA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_PRIMA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_CESANTIA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_APORTES_NOMINA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSULTA_ARTICULOS_MOVIL       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ARTICULO_MOVIL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTES_MOVIL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRA_RECIBO_FACTURA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_ITEM_FACTURA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTREGA_ITEM                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTREGA_FIN                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TERCEROS_CREADOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_INVENTARIO_FECHA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_NIIF_PROM_Y_ULT_UNIDAD   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_22                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_24                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_26                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_23                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CENTRO_TERCERO_MES TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COPIA_SALDOS_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CENTRO_TERCERO_MES     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRA_PROVISION             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CALCULA_CONSOLIDADO_FECHA      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALIDAS_ANO_ANTERIOR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDEN_SUGERIDA_TOTAL           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VARIACION_COSTOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_MANIFIESTO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10068                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_TAXONOMIA                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_TERCEROS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_EMPLEADOS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_MOVTERCEROS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_FACTURACIONPAPEL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM14_FACTURACIONPOS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODUCCION_NIIF       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCHEQ_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DESENSAMBLE_NIIF      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIQ_PARQUEADERO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_PARQUEADERO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODDEV_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODENT_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_PRODSAL_NIIF          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECIBO_RECAUDO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMICLIE_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCOMP_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMIPROV              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_TIEMPOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_REMIPROV_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRCL_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBCL_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PERIODO_NOM_FECHAF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_APLICACL_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTACRPR_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_CLIENTE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_CLIENTE             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_VENDEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_NOTADBPR_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_APLICAPR_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RECICAJA_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_EGRESO_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_33                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_34                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_COSTO_VENTAS_CONTADO  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_PEND_ALISTA_FACT          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DET_EMBALAJE_FACT         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_EMBALAJE_FACT             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_TRANSMIT              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_CONSUMO_VENTAS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_FACTELECTRONICA21       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PARTE_CADENA_COMAS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIUDAD_TERCERO                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_TERCEROS_CREADOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_FACTURAS_USUARIO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_FACTURAS_DETALLE        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRUNCAR_TELEFONO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCS_INVENTARIO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_SISMED                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ACTIVOS                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_36                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_310                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LISTA_PRECIOS_CON_ESCALA       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_COTIZA_WEB               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTOR_UNIDAD_CANT_EXCEP       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_EN_VENTAS_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGERIDO_BODEGA                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VACACIONES_NOMINA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLVER_ITEM_NEGATIVOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DETERIORO_CARTERA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_INICIAL_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESTAMOS_NOMINA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CENTRO_MES_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE LIBRO_DIARIO_CUENTA_N          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTO_CUENTA_MES_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BASE_APORTES                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_MES_NIIF               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_IVA_COMPRA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALARIO_PROMEDIO_DETALLE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ES_AFECTABLE_NIIF              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PENDIENTES_EVENTO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CON_TERCEROS_MES_N     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_ANUAL_NIIF             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MOVIMIENTOS_CUENTA_DE_HASTA_N  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILICE_EQUIVALENCIA_NIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_PRUEBA_ACUMULADO_NIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_CENTROS_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRECIOS_TODOS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRECIOS_SISMED             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_SISMED             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DOCUMENTOS_SERIAL              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SERIALES_ITEM_DOCUMENTO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_UNIDAD_BOD         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_AGENCIA_FP              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_SALDOS_CAJAS_FECHA     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BALANCE_CON_TERCEROS_ACUM      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_APORTE                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_CIERRE_COMP_INT       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_GASTOS_IMPORTACION   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_ARTICULOS_PROVEEDORI       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_FALTANTES_PROVEEDORI       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CONSECUTIVOS_IMP           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MMDIST_31                      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAUSA_RETENCION_LABORAL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP_INT          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DETERIORO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_FACTURA_WEB              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAR_EVENTO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_CLIENTES_BIT               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIO_TARIFA_IVA              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIO_PRECIOS_IVA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_VENDEDOR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_PUNTO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_PUNTO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_FECHA             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CHEQUEO_MOVIMIENTO_ARTICULO    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTES_MOVIL_OFFLINE    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLCLI_SIN_CONTABILIDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENSAMBLES_SIN_CONTABILIDAD_NIIFTO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTRADAS_SIN_CONTABILIDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_SIN_CONTABILIDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALIDAS_SIN_CONTABILIDAD_NIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRASLADOS_SIN_CONTABILDAD_NIIF TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_BIT                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTASDET_BIT              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CARTERA_CLIENTES_OFFLINE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_SKU_BIT                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_RUTAS_BIT                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ORDENINT                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABILIZA_PENDIENTE_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_ARTICULO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_FECHA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_INVENTARIO_AGOTADOS        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_VENTAS_GRUPO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_COMPRAS_GRUPO              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_COMPRAS_PROVEEDOR          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_CARTERA_CLIENTES           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_MOVIMIENTO_CLIENTES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_CXPAGAR                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_MOVIMIENTO_PROVEEDOR       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_RESUMEN_SALDOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_RESUMEN_CAJA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GER_RESUMEN_BANCOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_CXPAGAR               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_CARTERA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_CAJA                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_BANCOS                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_DETCART              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDENE_TARIFAS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_PRESTAMOS_NOMINA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONSOLIDADO_PROVISIONES        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ANALISIS_COMPRAS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAR_PEDIDOS               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTE_WEB               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTCOMP_INTN         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CIUDADES_MOVIL            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURA_ALQUILER_Y_TRANSPORTE  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDENES_COMPRA_ARTICULO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INF_CERTIFICADOS_RETENCION     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPRAS_RIMAR              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUADRE_CAJA_DETALLE_F          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_COSTOS_CONTADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_VENTAS_VENDEDOR_RIMAR      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTO_VENTAS_FECHAS            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALOR_INVENTARIO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_TOTAL_BANCOS             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CARTERA_TOTAL                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_GERENCIAL_RIMAR        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SUGERIDO_PROVEEDOR             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_SUGERIDO_PROVEEDOR         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CERTIFICADOS_RETENCION_NIIF    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_APORTE_NOV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIFERENCIAS_FACTURAS_BD        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REDONDEE_AP                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE SALDO_ARTICULO_MES_NIIF        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_FACTELECTRONICA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRODUCCION_PENDIENTE           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GENERE_ORDEN_INV_PLAN          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ENTRADAS_GRUPO_MES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIF                            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTOS_PRODUCCION              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECALCULA_COSTO_PROVC          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_CLIENTES_POSMOVIL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_SUBGRUPOS_POSMOVIL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ARTICULOS_POSMOVIL        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETFACTURA_POSMIVIL       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_FACTURA_POSMOVIL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_FACTURAS_VEND_POSMOVIL    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EGRESOS_DEVCONTADO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CIERRE_ABONOS_EFECTIVO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_COSTO_ENTRADAS         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_DETALLE_RETENCION          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_UTILIDAD_VENTAS_EX         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CRUCES_COMPRAS                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSQUEDA_FACTURAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_FACTPROFV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCAR_CLIENTES_MOVIL          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_ARTICULO_MOVILV2          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BUSCAR_ARTICULOS_MOVIL         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACCESO_USUARIO_MOVIL           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTPROFV             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_1001_10                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_10079                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_POR_EMPACAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TIPO_EMBALAJE_ALISTAMIENTO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETALLE_FACTURA_EMPAQUE   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AHORRO_TOTAL                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE BORRAR_FACTURA_WEB             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_FACTURAS_VEND             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CADENA_NUMERO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22762_N                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE MM_22762                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_COSTO_COMPRAS          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VER_ARTICULOS_FACTWEB          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DEVOLVER_FACTURA               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_RUTERO_NIIF           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIA_EMPLEADO                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_CTAART       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_CTAART_N     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_TIVA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_DEVOLCLI_TIVA_N       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PROMEDIO_SALIDAS_ARTICULOI     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ORDEN_SUGERIDA_TOTALI          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PEDIDOS_X_CLIENTE              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REVISA_PRECIOS_ARTICULO_COMPRASTO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_CTAART_N      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_TIVA_N        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ERRORINT_N                     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_EQUIVALENCIA_NIIF     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_PROGPAGO             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDE_ARTICULO_FAC            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARCHIVO_BANCO_CXP              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETALLE_FACTURA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_VENTAS_TIVA           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE FACTURAS_POR_ALISTAR           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TRAE_DETALLE_FACTURA_ALISTA    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_VENTAS_CONTADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_COSTOS_CONTADO        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COSTOS_PRODUCCION_NIIF         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_CUENTAS_NO_TERCERO     TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PUNTOS_DOCUMENTO               TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RESUMEN_PUNTOS_TX1             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE COMPARA_MOVCAJA_DOCCAJA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPR_ORDENSERV                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_ID_ORDENSER             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIE_FECHA_COMPROBANTE       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CREA_ARTICULOS_BD              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_NITA TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTUALICE_COSTOS_COMPRA        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COMPROBANTES_PROD          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CUENTA_MAL_AFECTABLE_N         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REGISTRE_SALIDA_DECIMALES      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE RECIBOS_TOTALES                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONCILIA_MOVCXPAGAR            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_COSTOSPROD                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REP_REMISIONES_ENTREGA         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IMPTOS_VENTAS_RESUMEN          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE NOMBRE_ALFANUMERICO            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_HISTORIAL_CHAT          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PROVEEDORES             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_TIVA          TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PROVEEDORES_CONSULTA    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_CATALOGO_ARTICULOS      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_BUSQUEDA_ARTICULOS      TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURA_CTAART        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_BUSCAFAC                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INACTIVAR_ACTUALIZACION_BALNIIFTO PUBLIC;
GRANT EXECUTE ON PROCEDURE ACTIVAR_ACTUALIZACION_BALNIIF  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_CTARTTO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_TIVA TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PEDIDOSVSFACTURAS              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_NA   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CONTABIL_FACTURAS_CONTADO_NT   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REMISIONES_SIN_CONTABILIDAD    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_FALTANTESPED            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_ARTICULOS_CREADOS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_CLIENTES_TIEMPO         TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AGREGA_COSTOS_VENTAS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_HISTORIAL_RECIBOS       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE REPORT_PRO_CONTACTOS           TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_TERCERO                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESENTACIONES_APP             TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_APP                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE PRESENTACIONES_OK              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INICIA_DESCARGA_PRESENTACIONES TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLIENTES_OK                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INICIA_DESCARGA_CLIENTES       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CAMBIOS_APP                    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_APP                TO PUBLIC;
GRANT EXECUTE ON PROCEDURE CLISUCURSALES_APP              TO PUBLIC;
GRANT EXECUTE ON PROCEDURE GRABE_SUCURSAL                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE TOTAL_INVENTARIO_FACTURABLE    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE VALIDA_BARRAS                  TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_OK                 TO PUBLIC;
GRANT EXECUTE ON PROCEDURE INICIA_DESCARGA_EXISTENCIAS    TO PUBLIC;
GRANT EXECUTE ON PROCEDURE EXISTENCIAS_MINIMO_PROV        TO PUBLIC;
GRANT EXECUTE ON PROCEDURE AJUSTES_SIN_CONTABILIDAD       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARREGLA_ENTRADAS_CONSUMO       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_LNR                       TO PUBLIC;
GRANT EXECUTE ON PROCEDURE DIAS_CAMBSAL                   TO PUBLIC;
GRANT EXECUTE ON PROCEDURE ARTICULOS_MILISTAPP            TO PUBLIC;
GRANT EXECUTE ON PROCEDURE IBC_MES_EMPLEADO               TO PUBLIC;

GRANT USAGE ON SEQUENCE RDB$SECURITY_CLASS             TO PUBLIC;
GRANT USAGE ON SEQUENCE SQL$DEFAULT                    TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$PROCEDURES                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$EXCEPTIONS                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$CONSTRAINT_NAME            TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$FIELD_NAME                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$INDEX_NAME                 TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$TRIGGER_NAME               TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$BACKUP_HISTORY             TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$FUNCTIONS                  TO PUBLIC;
GRANT USAGE ON SEQUENCE RDB$GENERATOR_NAME             TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORTE_ERRORES_ID         TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AJUSTECIE                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AJUSTEINF                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AJUSTEINV                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ALERTAS                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ANTICIPO_PROVEEDOR          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ANTICLIE                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_APLICACLIE                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_APLICAPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ARTICULO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AUDITORIA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_BANCO                       TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_BONOPAGO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBCOSTO                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBIODOC                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMPANA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMSITUA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CARGOGASTO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CHEQUES                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CIERANUAL                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CIERTERC                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COMPROBA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COMPROMISO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONCILIAB                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONFIRMDEPOS                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONS                        TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSIGNA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSIGNATAR                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSNO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSNOPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSOLIDA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSOLIDADO                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSUMOS                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONTABILIZA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COTIPROV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COTIZACI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CUENTA_BANCO                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DESENSAMBLE                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEVOLCLI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEVOLPROV                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEVOLUCION_CHEQUES          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DISFVACAC                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DOCPAGOCAJA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EGRESOS                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENSAMBLE                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENTRADA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENTRSALEMPL                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ENVIO                       TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ERRORES                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EVENTO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTCOMP                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTCONT                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTPER                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FACTURA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_FORMDATOS                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_HORAEMPL                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERBANCO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCAJA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCARTERA                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCMP                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCOMPRA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERCXPAGAR                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERFAZ_INVENTARIO         TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_INTERVTA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_LOTE                        TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MENSAJE                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVARTI                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVBANCO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVCAJA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVCLI                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVPROV                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVSALEMPL                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMICOMI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMINA                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMINA_PROV                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMI_NOVEDADES              TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTACRCLI                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTACRPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTADBCLI                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTADBPROV                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTADOC                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTASCLIENTES               TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTAS_CREDITO_BANCO         TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTAS_DEBITO_BANCO          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDEMBAR                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENCOMP                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENMCIA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENPROD                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PAGONOMI                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PAGO_CLIENTE                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PAGO_PROVEEDOR              TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PEDIDO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PENDIENTE                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PGAPORT                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PLANPROD                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PLANTILLA                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRESTAMOS                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRODDEV                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRODENT                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRODSAL                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PUNTOS                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PUNTOSVEND                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECICAJA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECIPROV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REDPTOSV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REMICLIE                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REMIPROV                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REPLARTICULO                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REPUTILIDAD                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RESERVA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RETENCIONES                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RETIROS                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REVPRECIO                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RUTERO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_SALIDA                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_SOLIMP                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TASACAMBIO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TERCERO                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TRANSFER                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TRASLACAJA                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TRASLADOS                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_VACACIONES                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PEDWEB                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTASESTADOS                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBPRECIO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_SORTEO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ARQUEO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_LIQUIDACION                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_TAXINST                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DEPRECIA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVCARGOEMP                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_MOVVINCULEMP                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CLIFACT                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONSNOMINA                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_IMPORTA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_AUTOCART                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EVENEXIS                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_GASTOIMP                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PRUEBA                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONCILIAPATD                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DETCART                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CONTRATOC                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_LIQRUTA                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECAUDO                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RELEVO                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REPLEVENTO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PARQUEADERO                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_CAMBART                     TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_TICKETS_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_NOTAS_ID            TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_FIRMA_ID            TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_ENVIOS_FO                  TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_BANDEJA_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_TITULOS_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_REEMFAC                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_ORDENSERV                   TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_CHAT                TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DOMICILIO_SENVIO            TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_CAMBIOS_ID          TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_PROGPAGO                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_VACACOL                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DENOMINA                    TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOMINAEXTRA                 TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_EMBARGO                     TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_RECAPP                      TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_NOTCARAPP                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_DOCINVWEB                   TO PUBLIC;
GRANT USAGE ON SEQUENCE ID_COSTONEG                    TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_CONEXION_ID         TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_AGENDA_CLIENTE_ID   TO PUBLIC;
GRANT USAGE ON SEQUENCE GEN_REPORT_AGENDA_PROVEEDOR_ID TO PUBLIC;

GRANT USAGE ON EXCEPTION ABONO_CERO                     TO PUBLIC;
GRANT USAGE ON EXCEPTION AJUSTE_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION ANO_INICIO_INCORRECTO          TO PUBLIC;
GRANT USAGE ON EXCEPTION APLICACIONCL_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION APLICACIONPR_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_CON_MOVIMIENTOS       TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_INACTIVO              TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_REGISTRADO            TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_SIN_PESO              TO PUBLIC;
GRANT USAGE ON EXCEPTION AUTORIZACION_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION AUTORIZACION_YA_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION BANCO_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION BODEGA_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION BONO_USADO                     TO PUBLIC;
GRANT USAGE ON EXCEPTION CAJA_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIODOC_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_CODIGO_CUENTA           TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_FECHA                   TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_SALARIO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION CANTIDAD_CRUCE_MAYOR           TO PUBLIC;
GRANT USAGE ON EXCEPTION CENTRO_CON_MOVIMIENTO          TO PUBLIC;
GRANT USAGE ON EXCEPTION CENTRO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION CIUDAD_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_CON_MOV                TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_CON_MOVIMIENTO         TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION COBRADOR_MOVIMIENTO            TO PUBLIC;
GRANT USAGE ON EXCEPTION COBRADOR_NOREG                 TO PUBLIC;
GRANT USAGE ON EXCEPTION COBRADOR_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION COMISIONES_CALCULADAS          TO PUBLIC;
GRANT USAGE ON EXCEPTION COMISIONES_REGISTRADAS         TO PUBLIC;
GRANT USAGE ON EXCEPTION COMPROBAENCABEZA_NO_EXISTE     TO PUBLIC;
GRANT USAGE ON EXCEPTION COMPROBANTE_DESCUADRADO        TO PUBLIC;
GRANT USAGE ON EXCEPTION COMPROBANTE_REGISTRADO         TO PUBLIC;
GRANT USAGE ON EXCEPTION CONCEPTO_ASIGNADO_EMPLEADO     TO PUBLIC;
GRANT USAGE ON EXCEPTION CONCEPTO_CON_MOVIMIENTO        TO PUBLIC;
GRANT USAGE ON EXCEPTION CONFIGURACION_NO_ENCONTRADA    TO PUBLIC;
GRANT USAGE ON EXCEPTION CONSIGNATAR_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION CONSIGNA_NO_EXISTA             TO PUBLIC;
GRANT USAGE ON EXCEPTION CONSUMO_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION CONTABILIDAD_BLOQUEADA         TO PUBLIC;
GRANT USAGE ON EXCEPTION COTIZACION_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTABANCO_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_CON_HIJAS               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_CON_MOVIMIENTOS         TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_CON_SALDO               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_NO_ES_NORMAL            TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_PADRE_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION CUENTA_SIN_DATOS               TO PUBLIC;
GRANT USAGE ON EXCEPTION CUPO_INSUFICIENTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION DESENSAMBLE_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION DEVOLUCIONPROD_NO_EXISTE       TO PUBLIC;
GRANT USAGE ON EXCEPTION DEVOLUCION_MAYOR               TO PUBLIC;
GRANT USAGE ON EXCEPTION DEVOLUCION_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_ABONO_MAYOR          TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_CONCILIADO           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_CON_ABONOS           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_CRUZADO              TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_DEVUELTO             TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_DE_OTRO_TERCERO      TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_FECHA_ABONO_ANTERIOR TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_PAGO_SALIDO          TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_REFERENCIADO         TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_REGISTRADO           TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_TOTALMENTE_CANCELADO TO PUBLIC;
GRANT USAGE ON EXCEPTION EFECTIVO_INSUFICIENTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION EGRESO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION ENSAMBLE_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION ENTRADAPROD_NO_EXISTE          TO PUBLIC;
GRANT USAGE ON EXCEPTION ENTRADA_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION ESTRUCTURA_INCORRECTA          TO PUBLIC;
GRANT USAGE ON EXCEPTION EXISTENCIA_INSUFICIENTE        TO PUBLIC;
GRANT USAGE ON EXCEPTION FACTOR_NO_ENCONTRADO           TO PUBLIC;
GRANT USAGE ON EXCEPTION FACTOR_PRECIO_MENOR            TO PUBLIC;
GRANT USAGE ON EXCEPTION FACTURA_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION FALTA_ACTIVO                   TO PUBLIC;
GRANT USAGE ON EXCEPTION FALTA_ARTICULO                 TO PUBLIC;
GRANT USAGE ON EXCEPTION FALTA_BASE                     TO PUBLIC;
GRANT USAGE ON EXCEPTION FECHA_ANTERIOR_DOCUMENTO       TO PUBLIC;
GRANT USAGE ON EXCEPTION FECHA_ANTERIOR_INICIO          TO PUBLIC;
GRANT USAGE ON EXCEPTION FECHA_NO_VALIDA                TO PUBLIC;
GRANT USAGE ON EXCEPTION FORMAPAGO_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION GRUPO_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION HORA_EXTRA_YA_UTILIZADA        TO PUBLIC;
GRANT USAGE ON EXCEPTION INTERFAZ_NO_ENCONTRADA         TO PUBLIC;
GRANT USAGE ON EXCEPTION LISTA_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_CON_MOVIMIENTOS           TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_NEGATIVO                  TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_OBLIGATORIO               TO PUBLIC;
GRANT USAGE ON EXCEPTION LOTE_PREVIO                    TO PUBLIC;
GRANT USAGE ON EXCEPTION MARCA_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION MES_YA_FACTURADO               TO PUBLIC;
GRANT USAGE ON EXCEPTION MOVIMIENTO_CUENTA_PADRE        TO PUBLIC;
GRANT USAGE ON EXCEPTION MOVIMIENTO_NO_CARTERA          TO PUBLIC;
GRANT USAGE ON EXCEPTION MOVIMIENTO_NO_INVENTARIO       TO PUBLIC;
GRANT USAGE ON EXCEPTION NIVEL_NO_AFECTABLE             TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_CON_PAGO                TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_OTRO_PERIODO            TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_REGISTRADA              TO PUBLIC;
GRANT USAGE ON EXCEPTION NO_HAY_BONO_DE_PAGO            TO PUBLIC;
GRANT USAGE ON EXCEPTION ORDEN_NO_EXISTE                TO PUBLIC;
GRANT USAGE ON EXCEPTION PAGO_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION PEDIDO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION PLANTILLA_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJOBANCO_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJO_CONTA_NOEXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJO_DEVCHEQUE              TO PUBLIC;
GRANT USAGE ON EXCEPTION PREFIJO_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION PRODUCCION_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION PROVEEDOR_CON_MOV              TO PUBLIC;
GRANT USAGE ON EXCEPTION PROVEEDOR_CON_MOVIMIENTO       TO PUBLIC;
GRANT USAGE ON EXCEPTION PROVEEDOR_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION PROYECTO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION PUNTOVTA_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION RANGO_DIAS_INCONSISTENTE       TO PUBLIC;
GRANT USAGE ON EXCEPTION RECIBO_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION REMISION_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION RUTA_NO_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDOCTA_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDO_INSUFICIENTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDO_SIN_CUENTA               TO PUBLIC;
GRANT USAGE ON EXCEPTION SALDO_SIN_TERCERO              TO PUBLIC;
GRANT USAGE ON EXCEPTION SALIDAPROD_NO_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION SALIDA_NO_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_ICPE                       TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UCC                        TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UCCP                       TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UCPE                       TO PUBLIC;
GRANT USAGE ON EXCEPTION SDP_UPR                        TO PUBLIC;
GRANT USAGE ON EXCEPTION SUBGRUPO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION SUCURSAL_CON_MOVIMIENTOS       TO PUBLIC;
GRANT USAGE ON EXCEPTION TARJETA_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION TASA_CAMBIO_REGISTRADA         TO PUBLIC;
GRANT USAGE ON EXCEPTION TERCERO_CON_MOV                TO PUBLIC;
GRANT USAGE ON EXCEPTION TERCERO_CON_SALDO              TO PUBLIC;
GRANT USAGE ON EXCEPTION TERCERO_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION TIPOCOMP_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION TIPODOC_NO_EXISTE              TO PUBLIC;
GRANT USAGE ON EXCEPTION TIQUETE_USADO                  TO PUBLIC;
GRANT USAGE ON EXCEPTION TRASFERENCIA_NO_EXISTE         TO PUBLIC;
GRANT USAGE ON EXCEPTION UNIDAD_CON_MOV                 TO PUBLIC;
GRANT USAGE ON EXCEPTION UNIDAD_NO_REGISTRADA           TO PUBLIC;
GRANT USAGE ON EXCEPTION VEHICULO_NO_EXISTE             TO PUBLIC;
GRANT USAGE ON EXCEPTION VENDEDOR_MOVIMIENTO            TO PUBLIC;
GRANT USAGE ON EXCEPTION VENDEDOR_NOREG                 TO PUBLIC;
GRANT USAGE ON EXCEPTION YA_EXISTE_EL_REGISTRO          TO PUBLIC;
GRANT USAGE ON EXCEPTION interfaz_no_definida           TO PUBLIC;
GRANT USAGE ON EXCEPTION CONCEPTO_CONTABLE_USADO        TO PUBLIC;
GRANT USAGE ON EXCEPTION ANTICPO_SIN_ORIGEN             TO PUBLIC;
GRANT USAGE ON EXCEPTION NOTA_YA_EXISTE                 TO PUBLIC;
GRANT USAGE ON EXCEPTION ARTICULO_CON_EXISTENCIA        TO PUBLIC;
GRANT USAGE ON EXCEPTION PERIODO_PAGADO                 TO PUBLIC;
GRANT USAGE ON EXCEPTION SORTEO_YA_EXISTE               TO PUBLIC;
GRANT USAGE ON EXCEPTION DATO_OBLIGATORIO               TO PUBLIC;
GRANT USAGE ON EXCEPTION ABONO_PRESTAMO_MAYOR           TO PUBLIC;
GRANT USAGE ON EXCEPTION CLIENTE_INACTIVO               TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_CARGO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION CAMBIO_VINCUL_EXISTE           TO PUBLIC;
GRANT USAGE ON EXCEPTION NOMINA_CON_APORTES             TO PUBLIC;
GRANT USAGE ON EXCEPTION VENCIMIENTO_INCORRECTO         TO PUBLIC;
GRANT USAGE ON EXCEPTION SERIAL_YA_USADO                TO PUBLIC;
GRANT USAGE ON EXCEPTION ACTIVO_SIN_MESES_DEPRECIACION  TO PUBLIC;
GRANT USAGE ON EXCEPTION ACTIVO_SIN_CUENTA              TO PUBLIC;
GRANT USAGE ON EXCEPTION EXISTENCIA_SOBRE_MAXIMO        TO PUBLIC;
GRANT USAGE ON EXCEPTION CODIGO_EAN_INCORRECTO          TO PUBLIC;
GRANT USAGE ON EXCEPTION DESCUENTO_MAYOR_AL_TOTAL       TO PUBLIC;
GRANT USAGE ON EXCEPTION PRECIO_MAYOR_TOPE              TO PUBLIC;
GRANT USAGE ON EXCEPTION CANTIDAD_MAYOR_DESCUENTO       TO PUBLIC;
GRANT USAGE ON EXCEPTION DOCUMENTO_NO_EXISTE            TO PUBLIC;
GRANT USAGE ON EXCEPTION AHORRO_MENOR                   TO PUBLIC;
GRANT USAGE ON EXCEPTION LISTA_IGUAL_BASE               TO PUBLIC;
GRANT USAGE ON EXCEPTION EMPLEADO_CON_MOVIMIENTO        TO PUBLIC;



INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'HORA DE FIN DE AGENDAMIENTO', '16', NULL, 'Indique la hora entera a que va a iniciar el agendamiento');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'HORA DE INICIO DE AGENDAMIENTO', '7', NULL, 'Indique la hora entera en que va a iniciar el agendamiento');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'INSERTAR NOTIFICACION DE LLEGADA DE CLIENTE', 'SI', 'SI,NO', 'SI: Envi notificacion al usuario de bodega NO:NO envia notificacion de llegada de cliente');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'INTERVALO DE TIEMPO DEL AGENDAMIENTO', '15', NULL, 'Indique el intervalo entre horas del agendamiento');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'NUMERO DE DIAS PARA CONSULTAR DOCUMENTOS', '360', NULL, 'Permite llamar documentos de los dias indicados hacia atras.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'PERMITIR MODIFICAR AGENDA YA FACTURADA', 'NO', 'SI,NO', 'Permite cambiar una agenda que ya fue facturada');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'PERMITIR MODIFICAR HORA DE LLEGADA DEL CLIENTE', 'NO', 'SI,NO', 'Permite modificar la hora de llegada del cliente.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'USUARIO PARA ENVIAR MENSAJE DE NOTIFICACION', 'SYSDBA', NULL, 'Digite el nombre del usuario al cual le llegaran las notificaciones a SYSplus');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'PROVEEDOR', 'HORA DE FIN DE AGENDAMIENTO', '16', NULL, 'Indique la hora entera a que va a iniciar el agendamiento');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'PROVEEDOR', 'HORA DE INICIO DE AGENDAMIENTO', '8', NULL, 'Indique la hora entera en que va a iniciar el agendamiento');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'PROVEEDOR', 'INTERVALO DE TIEMPO DEL AGENDAMIENTO', '15', NULL, 'Indique el intervalo entre horas del agendamiento');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'PROVEEDOR', 'PERMITIR AGENDAMIENTO SIN ORDENES', 'NO', 'SI,NO', 'Permite guardar programacion de agenda sin llamar alguna orden.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'PROVEEDOR', 'PERMITIR MODIFICAR LA RECEPCION DE LOGISTICA', 'NO', 'SI,NO', 'Permite cambiar la recepcion de logistica que ya etsa grabada.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AJUSTES', 'GENERAL', 'COLOR FINAL VENTANA PRINCIPAL REPORT', '0,0,0', '0x00000-0xFFFFFF', 'Indique el color en formato RGB que quiere de fondo en la ventana final del módulo');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AJUSTES', 'GENERAL', 'COLOR VENTANA PRINCIPAL REPORT', '23,224,255', '0x00000-0xFFFFFF', 'Indique el color en formato RGB que quiere de fondo en la ventana principal del módulo');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AJUSTES', 'GENERAL', 'RUTA DE CARPETA EN RED PARA MANEJO DE PUBLICIDAD', '192.168.0.14:C:\SYSplus2020', NULL, 'Digite la ruta en red donde estara la carpeta para buscar la publicidad.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AJUSTES', 'GENERAL', 'TIPO DE GRADADO PARA EL MODULO', '5', '1,2,3,4,5,6,7,8,9', 'Selecciona un degradado para los colores del ventana 1(Horizontal), 2(Verticall),3(Esquina_1),4(Esquina_2),5(Esquina_3),6(Esquina_4),7(Circular),8(Central),9(Agua).');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AJUSTES', 'GENERAL', 'USAR CARPETA DEL EQUIPO LOCAL O RED', 'LOCAL', 'LOCAL,RED', 'LOCAL: La carpeta Pulicidad debe estar en la ruta de instalacion  RED:Buscar una carpeta en red.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('COMPRAS', 'CAMBIOS', 'NUMERO DE FACTURA OBLIGATORIO AL REGISTRAR CAMBIO', 'NO', 'SI,NO', 'No permite guardar el cambio si no tiene el numero de factura asociado');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('COMPRAS', 'GENERAL', 'COLOR FINAL VENTANA PRINCIPAL REPORT', '23,224,255', '0x00000-0xFFFFFF', 'Indique el color en formato RGB que quiere de fondo en la ventana final del módulo');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('COMPRAS', 'GENERAL', 'COLOR VENTANA PRINCIPAL REPORT', '0,0,0', '0x00000-0xFFFFFF', 'Indique el color en formato RGB que quiere de fondo en la ventana principal del módulo');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('COMPRAS', 'GENERAL', 'TIPO DE GRADADO PARA EL MODULO', '6', '1,2,3,4,5,6,7,8,9', 'Selecciona un degradado para los colores del ventana 1(Horizontal), 2(Verticall),3(Esquina_1),4(Esquina_2),5(Esquina_3),6(Esquina_4),7(Circular),8(Central),9(Agua).');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'CODIGO DE MARCA PARTNER', '210729', NULL, 'Digite el codigo partner de convenio');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'CONTRASENA DE FTP PARA ENVIO DE ARCHIVOS', '$0p0rt31DSH', NULL, 'Digite la contrasena del FTP');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'CUENTA FTP PARA ENVIO DE ARCHIVOS', 'ftp.alianzadsh.com', NULL, 'Digite el usuaruio del FTP');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'MARCA PREDERTERMINADA PARA GENERAR REPORTE', '043', NULL, 'Digite codigo de marca predeterminada para generar reporte FTP.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'NUMERO DE SEGUNDOS PARA NOTIFICAR BUSQUEDA DE ENVIO', '10', NULL, 'Ingrese en segundos la frecuencia de validacion de envios en el servidor.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'PUERTO PARA FTP', '22', NULL, 'Digite le puerto de envio FTP');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'RUTA PARA EXPORTAR ARCHIVO EXCEL', 'C:\SYSplus2019', NULL, 'Digite ruta donde guardar archivo y convertir para FTP');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'SMFTP DIRECTORIO PARA ENVIO', '/home/alianzadsh', NULL, 'Digite el directorio del FTP donde se guardara el archivo.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('ENVIO', 'GENERAL', 'USUARIO FTP', 'alianzadsh', NULL, 'Digite Usuario del FPT');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('TICKETS', 'GENERAL', 'TIPO DE GRADADO PARA EL MODULO', '8', '1,2,3,4,5,6,7,8,9', 'Selecciona un degradado para los colores del ventana 1(Horizontal), 2(Verticall),3(Esquina_1),4(Esquina_2),5(Esquina_3),6(Esquina_4),7(Circular),8(Central),9(Agua).');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'FALTANTES', 'MOSTRAR PENDIENTES POR USUARIO,PUNTO,NO', 'USUARIO', 'USUARIO,PUNTO,NO', 'Permite mostrar los pendientes por Usuario, Punto de venta o No filtrar.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'GENERAL', 'LLEVAR CONTROL DE ENVIOS POR FACTURAS', 'NO', 'SI,NO', 'SI:Permite insertar y controlar los enviospor factura NO:No lleva control.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'GENERAL', 'LLEVAR CONTROL DE FALTANTES POR FACTURAS', 'SI', 'SI,NO', 'SI:Permite insertar y controlar faltantes por facturas NO:No lleva control.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'GENERAL', 'LLEVAR CONTROL DE FALTANTES POR REMISIONES', 'SI', 'SI,NO', 'SI:Permite insertar y controlar faltantes por remision NO:No lleva control.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'GENERAL', 'MOSTRAR PENDIENTES POR USUARIO', 'NO', 'NO,USUARIO', 'NO:Muestra todos los pedidos pendientes en un rango de fecha. USUARIO:Muestra unicamente los pedidos pendientes por enviar al usuario conectado.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'GENERAL', 'NOTIFICAR EN PANTALLA CANTIDAD DE FACTURAS PENDIENTES POR ASIGNAR DOMICILIO.', 'NO', 'SI,NO', 'Permite ver en pantalla en un intervalo de tiempo la cantidad de facturas que no han sido asignadas a un domiciliario.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'GENERAL', 'TIEMPO PARA REFRESCAR VENTANA EN MINUTOS', '1', '1,2,3,4,5,6,7,8,9,10,15,20,30,60', 'Seleccione el tiempo en minutos que se van a refrescar las consultas.');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'GENERAL', 'TIPO DE GRADADO PARA EL MODULO', '9', '1,2,3,4,5,6,7,8,9', 'Selecciona un degradado para los colores del ventana 1(Horizontal), 2(Verticall),3(Esquina_1),4(Esquina_2),5(Esquina_3),6(Esquina_4),7(Circular),8(Central),9(Agua).');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'PRECIOS', 'CODIGO DE LISTA FINAL PARA ESCALAS', '0', '0,1,2,3,4,5,6,7,8,9', 'Digite el codigo de lista de precios para rango de escalas en la consulta');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('VENTAS', 'PRECIOS', 'CODIGO DE LISTA INICIAL PARA ESCALAS', '0', '0,1,2,3,4,5,6,7,8,9', 'Digite el codigo de lista de precios para rango de escalas en la consulta');

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2021/12/14';

ALTER TABLE REPORT_AGENDA_CLIENTE
ADD AGENDA_CITA CHAR(1)
DEFAULT 'S' ;

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2021/12/15';

INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'INACTIVAR CASILLAS EN PROCESO DE FACTURACION', 'NO', 'SI,NO', 'Permite bloquear y evitar cambios a la hora de registrar el proceso de facturacion');

ALTER TABLE REPORT_AGENDA_PROVEEDOR
ADD APROV_ASESORINI VARCHAR(60);

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2021/12/17';

SET TERM ^ ;

CREATE OR ALTER trigger report_agenda_cliente_bi for report_agenda_cliente
active before insert position 0
as
DECLARE VARIABLE NUMERO VARCHAR(8);
DECLARE VARIABLE AUTOM CHAR(1);
DECLARE VARIABLE EXISTE CHAR(1);
DECLARE VARIABLE ESTADO CHAR(1);
DECLARE VARIABLE CANT INTEGER;
begin
  if (new.id_agenda is null) then
    new.id_agenda = gen_id(gen_report_agenda_cliente_id,1);

      /*VACIO USUARIO*/
  IF (NEW.AGENDA_USUARIO IS NULL) THEN
     NEW.AGENDA_USUARIO = USER;

       /* VALIDE EL ESTADO DEL CLIENTE */
  BEGIN
    SELECT C.CLIE_ESTADO
    FROM CLIENTES C
    WHERE TERC_NIT = NEW.TERC_NIT
    INTO :ESTADO;
    IF (ESTADO <> 'A') THEN
      EXCEPTION CLIENTE_INACTIVO 'El cliente ' || NEW.TERC_NIT || ' esta inactivo o en No vender.';
  END

    /* Verifique que el numero no existe previamente */
  EXISTE = 'N';
  SELECT 'S'
  FROM REPORT_AGENDA_CLIENTE
  WHERE PREF_PRE = NEW.PREF_PRE AND
        AGENDA_NUMERO = NEW.AGENDA_NUMERO
  INTO :EXISTE;
  IF (EXISTE = 'S') THEN
    EXCEPTION DOCUMENTO_REGISTRADO 'Ya existe un agendamiento con el numero ' || NEW.PREF_PRE || NEW.AGENDA_NUMERO;

    BEGIN
    /* Actualice el contador del prefijo */
    SELECT NUMERO_PREFIJO, CALCULO_PREFIJO
    FROM REPORT_PREFIJOS
    WHERE TIDO_COD = 1 AND
          PREF_PREFIJO = NEW.PREF_PRE
    INTO :NUMERO, :AUTOM;
    /* ACTUALICE EL NUMERO EN ENCABEZADO  */
    IF (AUTOM = 'S') THEN
    BEGIN
      NEW.AGENDA_NUMERO = NUMERO;
      NUMERO = CAST((CAST(NUMERO AS INTEGER) + 1) AS CHAR(8));
      UPDATE REPORT_PREFIJOS
      SET NUMERO_PREFIJO = :NUMERO
      WHERE TIDO_COD = 1 AND
            PREF_PREFIJO = NEW.PREF_PRE;
    END
    ELSE
    BEGIN
      IF (CAST(NUMERO AS INTEGER) = CAST(NEW.AGENDA_NUMERO AS INTEGER)) THEN
        UPDATE REPORT_PREFIJOS
        SET NUMERO_PREFIJO = CAST((CAST(NUMERO_PREFIJO AS INTEGER) + 1) AS CHAR(8))
        WHERE TIDO_COD = 1 AND
              PREF_PREFIJO = NEW.PREF_PRE;
    END
    EXECUTE PROCEDURE COMPLETA_CEROS8(NEW.AGENDA_NUMERO)
        RETURNING_VALUES (NEW.AGENDA_NUMERO);
  END

  /*Valide que no inserte una agenda con la misma hora y fecha*/
    SELECT COUNT (*) FROM REPORT_AGENDA_CLIENTE WHERE AGENDA_FECHA = NEW.AGENDA_fecha AND AGENDA_HORA = NEW.AGENDA_hora AND AGENDA_ANULADO='N' INTO :CANT;
    IF(CANT > 0) THEN
    exception  YA_EXISTE_EL_REGISTRO 'Ya existe un agendamiento con esa fecha y hora ' || new.AGENDA_fecha ;
end^

SET TERM ; ^

ALTER TABLE REPORT_AGENDA_CLIENTE
ADD AGENDA_NOTIFICA CHAR(1)
DEFAULT 'N' ;

UPDATE REPORT_AGENDA_CLIENTE SET AGENDA_NOTIFICA = 'N' WHERE AGENDA_NOTIFICA IS NULL;

SET TERM ^ ;

CREATE OR ALTER procedure REPORT_ALERTA_VISTAS (
    FECINI date)
returns (
    MENSAJE varchar(255))
as
declare variable MINUTOS integer;
declare variable TERCERO varchar(60);
begin
  for select ((AGENDA_HORA-current_time)/60) AS MINUTOS, agenda_NOMBREC
      from REPORT_AGENDA_CLIENTE WHERE AGENDA_ANULADO = 'N' AND AGENDA_FECHA = :fecini
      into MINUTOS , TERCERO
           DO
           IF (MINUTOS >=0 AND MINUTOS <=15 and MINUTOS IS NOT NULL) then
           MENSAJE = 'El cliente '||:TERCERO||' esta proximo a llegar '||:minutos||' minutos.';
           suspend;
end^

SET TERM ; ^

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2021/12/22';

/*No actualizaba bien las alertas*/
SET TERM ^ ;

CREATE OR ALTER procedure REPORT_ALERTA_VISTAS (
    FECINI date)
returns (
    MENSAJE varchar(255),
    DOC integer)
as
declare variable MINUTOS integer;
declare variable TERCERO varchar(60);
declare variable ID integer;
begin
  MENSAJE = NULL;
  for select first 1 ((AGENDA_HORA-current_time)/60) AS MINUTOS, agenda_NOMBREC, ID_AGENDA
      from REPORT_AGENDA_CLIENTE WHERE AGENDA_ANULADO = 'N' AND AGENDA_FECHA = :fecini AND AGENDA_NOTIFICA = 'N'
      into MINUTOS , TERCERO , :ID
           DO
           IF (MINUTOS >=1 AND MINUTOS <=15 and ((MINUTOS IS NOT NULL) or (MINUTOS >0) )) then
           MENSAJE = 'El cliente '||:TERCERO||' esta proximo a llegar '||:minutos||' minutos.';
          -- UPDATE REPORT_AGENDA_CLIENTE SET AGENDA_NOTIFICA = 'S' WHERE ID_AGENDA = :ID;
           if (mensaje is null) then
           DOC = null;
           else
           doc =:ID;
           suspend;
end^

SET TERM ; ^

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2021/12/27';

ALTER TABLE REPORT_CONEXION
ADD FBI_CONEXION INTEGER;

ALTER TABLE REPORT_CONEXION
ADD FECHA_CONEXION DATE;

SET TERM ^ ;

CREATE OR ALTER trigger report_conexion_bi for report_conexion
active before insert position 0
as
begin
  if (new.id_conexion is null) then
    new.id_conexion = gen_id(gen_report_conexion_id,1);
  if (NEW.hora_conexion IS NULL ) then
  NEW.hora_conexion = current_time;
  if (NEW.fbi_conexion IS NULL ) then
  NEW.fbi_conexion = current_connection;
   if (NEW.fecha_conexion IS NULL ) then
  NEW.fecha_conexion = current_date;
end^

SET TERM ; ^

SET TERM ^ ;

CREATE OR ALTER trigger report_conexion_ti for report_conexion
active before insert position 0
AS
begin
execute procedure REPORT_VALIDA_CONEXIONES;
end^

SET TERM ; ^

SET TERM ^ ;

CREATE OR ALTER procedure REPORT_VALIDA_CONEXIONES
as
declare variable ID integer;
declare variable CANT integer;
declare variable FECHA date;
begin
  FOR SELECT FBI_CONEXION , FECHA_CONEXION FROM REPORT_CONEXION
  INTO :ID , :FECHA
  DO
  BEGIN
  if (FECHA < current_date) then
      select COUNT(*) from MON$ATTACHMENTS WHERE MON$ATTACHMENT_ID = :ID INTO :CANT;
      if (CANT=0) then
         DELETE FROM REPORT_CONEXION WHERE FBI_CONEXION =:ID;
  END
end^

SET TERM ; ^

GRANT EXECUTE ON PROCEDURE REPORT_VALIDA_CONEXIONES TO PUBLIC;

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/01/21';

ALTER TABLE REPORT_AGENDA_PROVEEDOR ADD APROV_TERMINA CHAR DEFAULT 'N';
ALTER TABLE report_agenda_proveedor ADD CHECK (APROV_TERMINA = 'N' OR APROV_TERMINA = 'S');

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer       ***/
/******************************************************************************/
SET SQL DIALECT 3;

CREATE GENERATOR GEN_REPORT_AGENDA_PROVEEDOR_ID;

SET TERM ^ ;



CREATE OR ALTER TRIGGER REPORT_AGENDA_PROVEEDOR_BI FOR REPORT_AGENDA_PROVEEDOR
ACTIVE BEFORE INSERT POSITION 0
as
DECLARE VARIABLE NUMERO VARCHAR(8);
DECLARE VARIABLE AUTOM CHAR(1);
DECLARE VARIABLE EXISTE CHAR(1);
DECLARE VARIABLE ESTADO CHAR(1);
DECLARE VARIABLE CANT INTEGER;
begin
  /*Valida que la fecha no quede vacio*/
  if (NEW.aprov_registro IS NULL) then
  NEW.aprov_registro = current_date;
  /*Valida que no quede vacio el id*/
  if (new.aprov_id is null) then
    new.aprov_id = gen_id(gen_report_agenda_proveedor_id,1);
    /* Verifique que el numero no existe previamente */
  EXISTE = 'N';
  SELECT 'S'
  FROM REPORT_AGENDA_PROVEEDOR
  WHERE PREF_PRE = NEW.PREF_PRE AND
        APROV_NUMERO = NEW.APROV_NUMERO and APROV_ANULADO ='N'
  INTO :EXISTE;
  IF (EXISTE = 'S') THEN
  EXCEPTION DOCUMENTO_REGISTRADO 'Ya existe un agendamiento con el numero ' || NEW.PREF_PRE || NEW.APROV_NUMERO;

  BEGIN
    /* Actualice el contador del prefijo */
    SELECT NUMERO_PREFIJO, CALCULO_PREFIJO
    FROM REPORT_PREFIJOS
    WHERE TIDO_COD = 2 AND
          PREF_PREFIJO = NEW.PREF_PRE
    INTO :NUMERO, :AUTOM;
    /* ACTUALICE EL NUMERO EN ENCABEZADO  */
    IF (AUTOM = 'S') THEN
    BEGIN
      NEW.APROV_NUMERO = NUMERO;
      NUMERO = CAST((CAST(NUMERO AS INTEGER) + 1) AS CHAR(8));
      UPDATE REPORT_PREFIJOS
      SET NUMERO_PREFIJO = :NUMERO
      WHERE TIDO_COD = 2 AND
            PREF_PREFIJO = NEW.PREF_PRE;
    END
    ELSE
    BEGIN
      IF (CAST(NUMERO AS INTEGER) = CAST(NEW.APROV_NUMERO AS INTEGER)) THEN
        UPDATE REPORT_PREFIJOS
        SET NUMERO_PREFIJO = CAST((CAST(NUMERO_PREFIJO AS INTEGER) + 1) AS CHAR(8))
        WHERE TIDO_COD = 2 AND
              PREF_PREFIJO = NEW.PREF_PRE;
    END
    EXECUTE PROCEDURE COMPLETA_CEROS8(NEW.APROV_NUMERO)
        RETURNING_VALUES (NEW.APROV_NUMERO);
  END

  /*Valide que no inserte una agenda con la misma hora y fecha*/
    SELECT COUNT (*) FROM REPORT_AGENDA_PROVEEDOR WHERE APROV_FECHA = NEW.aprov_fecha AND APROV_HORA = NEW.aprov_hora INTO :CANT;
    IF(CANT > 0) THEN
    exception  YA_EXISTE_EL_REGISTRO 'Ya existe un agendamiento con esa fecha y hora ' || new.aprov_fecha ;
  /*No permite null*/
  IF(NEW.APROV_ASISTENTES IS NULL) THEN
    NEW.APROV_ASISTENTES = 0;
end
^


SET TERM ; ^

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/01/28';

ALTER TABLE REPORT_PERMISOS
ADD NOMBRE_PERMISO VARCHAR(60)

/*Permisos de usuarios*/

SET TERM ^ ;

CREATE OR ALTER procedure REPORT_ACESSO_USUARIO (
    USUARIO varchar(10),
    MODULO varchar(20),
    OPCION integer)
returns (
    PERMISO char(1))
as
declare variable SQL varchar(512);
declare variable SERVER varchar(512);
declare variable USUGEN varchar(10);
declare variable CLAVE varchar(20);
declare variable ADMI char(1);
begin
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'NOMBRE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (USUGEN);
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'CLAVE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (CLAVE);
  select rdb$get_context('SYSTEM', 'DB_NAME') from rdb$database INTO :SERVER;
  SERVER = left(SERVER, STRLEN(SERVER) - 15);
  SERVER = SERVER || 'GENERAL.FDB';
  SQL = 'SELECT USUA_ADMIN FROM USUARIO WHERE USUA_COD = '''||:USUARIO||'''';
  EXECUTE STATEMENT :SQL ON EXTERNAL :SERVER as user :USUGEN PASSWORD :CLAVE INTO :ADMI;
  if (admi = 'S') then
    BEGIN
    PERMISO = 'S';
    suspend;
    END
  ELSE
    BEGIN
    SELECT ACCESO_PERMISOS FROM REPORT_PERMISOS WHERE USUARIO_PERMISOS = :USUARIO AND MODULO_PERMISOS = :MODULO and OPCION_PERMISOS = :OPCION
        INTO :PERMISO;
    suspend;
    END
end^

SET TERM ; ^

GRANT EXECUTE ON PROCEDURE REPORT_ACESSO_USUARIO TO "PUBLIC";
GRANT EXECUTE ON PROCEDURE REPORT_ACESSO_USUARIO TO SYSDBA;

SET TERM ^ ;

create or alter procedure REPORT_USUARIO
returns (
    CODIGO varchar(10),
    NOMBRE varchar(60),
    ADMINISTRADOR char(1))
as
declare variable SQL varchar(512);
declare variable SERVER varchar(512);
declare variable USUGEN varchar(10);
declare variable CLAVE varchar(20);
declare variable ADMI char(1);
declare variable UCOD varchar(10);
begin
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'NOMBRE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (USUGEN);
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'CLAVE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (CLAVE);


  select rdb$get_context('SYSTEM', 'DB_NAME') from rdb$database INTO :SERVER;
  SERVER = left(SERVER, STRLEN(SERVER) - 15);
  SERVER = SERVER || 'GENERAL.FDB';
  SQL = 'SELECT USUA_COD, USUA_NOMBRE , USUA_ADMIN FROM USUARIO';
  FOR EXECUTE STATEMENT :SQL ON EXTERNAL :SERVER as user :USUGEN PASSWORD :CLAVE INTO :CODIGO,:NOMBRE, :ADMINISTRADOR
  DO
  suspend;

end^

SET TERM ; ^

/* Following GRANT statetements are generated automatically */

GRANT EXECUTE ON PROCEDURE LEE_CONFIGURACION TO PROCEDURE REPORT_USUARIO;

/* Existing privileges on this procedure */

GRANT EXECUTE ON PROCEDURE REPORT_USUARIO TO "PUBLIC";
GRANT EXECUTE ON PROCEDURE REPORT_USUARIO TO SYSDBA;

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/02/10';

CREATE TABLE REPORT_TIPO_USARIO (
    USUARIO_COD VARCHAR(10) NOT NULL,
    USUARIO_ADM CHAR(1));

ALTER TABLE REPORT_TIPO_USARIO
ADD CONSTRAINT PK_REPORT_TIPO_USARIO
PRIMARY KEY (USUARIO_COD);

GRANT ALL ON TABLE REPORT_TIPO_USARIO TO PUBLIC;

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/05';



CREATE TABLE REPORT_TIPO_USUARIO (
    USUARIO_COD  VARCHAR(10) NOT NULL,
    USUARIO_ADM  CHAR(1)
);

ALTER TABLE REPORT_TIPO_USUARIO ADD CONSTRAINT PK_REPORT_TIPO_USUARIO PRIMARY KEY (USUARIO_COD);


/* Privileges of users */
GRANT ALL ON REPORT_TIPO_USUARIO TO PUBLIC;

DROP TABLE REPORT_TIPO_USARIO;

SET TERM ^ ;

create or alter procedure REPORT_TIPO_USER
as
declare variable SQL varchar(512);
declare variable SERVER varchar(512);
declare variable USUGEN varchar(10);
declare variable CLAVE varchar(20);
declare variable ADMI char(1);
declare variable CANT integer;
declare variable PUSER varchar(10);
begin
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'NOMBRE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (USUGEN);
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'CLAVE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (CLAVE);
  select rdb$get_context('SYSTEM', 'DB_NAME') from rdb$database INTO :SERVER;
  SERVER = left(SERVER, STRLEN(SERVER) - 15);
  SERVER = SERVER || 'GENERAL.FDB';
  SQL = 'SELECT USUA_COD, USUA_ADMIN FROM USUARIO';
  FOR EXECUTE STATEMENT :SQL ON EXTERNAL :SERVER as user :USUGEN PASSWORD :CLAVE INTO :PUSER ,:ADMI
  DO
  BEGIN
  SELECT COUNT (*) FROM REPORT_TIPO_USUARIO WHERE USUARIO_COD = :PUSER INTO :cant;
  if (cant=0) then
  insert into REPORT_TIPO_USUARIO (USUARIO_COD, USUARIO_ADM)
  values (:Puser, :admi)  ;
  END
end^

SET TERM ; ^

/* Following GRANT statetements are generated automatically */

GRANT EXECUTE ON PROCEDURE LEE_CONFIGURACION TO PROCEDURE REPORT_TIPO_USER;
GRANT SELECT,INSERT ON REPORT_TIPO_USUARIO TO PROCEDURE REPORT_TIPO_USER;

/* Existing privileges on this procedure */

GRANT EXECUTE ON PROCEDURE REPORT_TIPO_USER TO SYSDBA;

SET TERM ^ ;



CREATE OR ALTER TRIGGER RPC_VALIDAUSER
INACTIVE ON CONNECT POSITION 0
as
declare variable SQL varchar(512);
declare variable SERVER varchar(512);
declare variable USUGEN varchar(10);
declare variable CLAVE varchar(20);
declare variable ADMI char(1);
declare variable CANT integer;
declare variable PUSER varchar(10);
begin
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'NOMBRE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (USUGEN);
EXECUTE PROCEDURE lee_configuracion('INVENTARIO', 'ARTICULOS', 'CLAVE DE USUARIO PARA REPLICACION DE ARTICULOS') returning_values (CLAVE);
  select rdb$get_context('SYSTEM', 'DB_NAME') from rdb$database INTO :SERVER;
  SERVER = left(SERVER, STRLEN(SERVER) - 15);
  SERVER = SERVER || 'GENERAL.FDB';
  SQL = 'SELECT USUA_COD, USUA_ADMIN FROM USUARIO';
  FOR EXECUTE STATEMENT :SQL ON EXTERNAL :SERVER as user :USUGEN PASSWORD :CLAVE INTO :PUSER ,:ADMI
  DO
  BEGIN
  SELECT COUNT (*) FROM REPORT_TIPO_USUARIO WHERE USUARIO_COD = :PUSER INTO :cant;
  if (cant=0) then
  insert into REPORT_TIPO_USUARIO (USUARIO_COD, USUARIO_ADM)
  values (:Puser, :admi)  ;
  END
end
^


SET TERM ; ^

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/09';

SET TERM ^ ;

create or alter procedure REPORT_ACESSO_USUARIO (
    USUARIO varchar(10),
    MODULO varchar(20),
    OPCION integer)
returns (
    PERMISO char(1))
as
declare variable ADMI char(1);
begin
  SELECT USUARIO_ADM FROM REPORT_TIPO_USUARIO WHERE USUARIO_COD = :USUARIO INTO ADMI;
  if (admi = 'S') then
    BEGIN
    PERMISO = 'S';
    suspend;
    END
  ELSE
    BEGIN
    SELECT ACCESO_PERMISOS FROM REPORT_PERMISOS WHERE USUARIO_PERMISOS = :USUARIO AND MODULO_PERMISOS = :MODULO and OPCION_PERMISOS = :OPCION
        INTO :PERMISO;
    suspend;
    END
end^

SET TERM ; ^

/* Following GRANT statetements are generated automatically */

GRANT SELECT ON REPORT_TIPO_USUARIO TO PROCEDURE REPORT_ACESSO_USUARIO;
GRANT SELECT ON REPORT_PERMISOS TO PROCEDURE REPORT_ACESSO_USUARIO;

/* Existing privileges on this procedure */

GRANT EXECUTE ON PROCEDURE REPORT_ACESSO_USUARIO TO "PUBLIC";
GRANT EXECUTE ON PROCEDURE REPORT_ACESSO_USUARIO TO SYSDBA;

ALTER TABLE REPORT_AGENDA_CLIENTE
ADD AGENDA_FSALIDA FECHA;

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/10';

ALTER TABLE REPORT_AGENDA_CLIENTE
ADD AGENDA_SALASESOR VARCHAR(60);

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/12';

ALTER TABLE REPORT_AGENDA_PROVEEDOR
ADD APROV_USUARIO VARCHAR(10);

SET TERM ^ ;

CREATE OR ALTER trigger report_agenda_proveedor_bi for report_agenda_proveedor
active before insert position 0
as
DECLARE VARIABLE NUMERO VARCHAR(8);
DECLARE VARIABLE AUTOM CHAR(1);
DECLARE VARIABLE EXISTE CHAR(1);
DECLARE VARIABLE ESTADO CHAR(1);
DECLARE VARIABLE CANT INTEGER;
begin
  /*Valide si el usuario esta vacio*/
  if (NEW.aprov_usuario IS NULL) then
  NEW.aprov_usuario = current_user;
  /*Valida que la fecha no quede vacio*/
  if (NEW.aprov_registro IS NULL) then
  NEW.aprov_registro = current_date;
  /*Valida que no quede vacio el id*/
  if (new.aprov_id is null) then
    new.aprov_id = gen_id(gen_report_agenda_proveedor_id,1);
    /* Verifique que el numero no existe previamente */
  EXISTE = 'N';
  SELECT 'S'
  FROM REPORT_AGENDA_PROVEEDOR
  WHERE PREF_PRE = NEW.PREF_PRE AND
        APROV_NUMERO = NEW.APROV_NUMERO and APROV_ANULADO ='N'
  INTO :EXISTE;
  IF (EXISTE = 'S') THEN
  EXCEPTION DOCUMENTO_REGISTRADO 'Ya existe un agendamiento con el numero ' || NEW.PREF_PRE || NEW.APROV_NUMERO;

  BEGIN
    /* Actualice el contador del prefijo */
    SELECT NUMERO_PREFIJO, CALCULO_PREFIJO
    FROM REPORT_PREFIJOS
    WHERE TIDO_COD = 2 AND
          PREF_PREFIJO = NEW.PREF_PRE
    INTO :NUMERO, :AUTOM;
    /* ACTUALICE EL NUMERO EN ENCABEZADO  */
    IF (AUTOM = 'S') THEN
    BEGIN
      NEW.APROV_NUMERO = NUMERO;
      NUMERO = CAST((CAST(NUMERO AS INTEGER) + 1) AS CHAR(8));
      UPDATE REPORT_PREFIJOS
      SET NUMERO_PREFIJO = :NUMERO
      WHERE TIDO_COD = 2 AND
            PREF_PREFIJO = NEW.PREF_PRE;
    END
    ELSE
    BEGIN
      IF (CAST(NUMERO AS INTEGER) = CAST(NEW.APROV_NUMERO AS INTEGER)) THEN
        UPDATE REPORT_PREFIJOS
        SET NUMERO_PREFIJO = CAST((CAST(NUMERO_PREFIJO AS INTEGER) + 1) AS CHAR(8))
        WHERE TIDO_COD = 2 AND
              PREF_PREFIJO = NEW.PREF_PRE;
    END
    EXECUTE PROCEDURE COMPLETA_CEROS8(NEW.APROV_NUMERO)
        RETURNING_VALUES (NEW.APROV_NUMERO);
  END

  /*Valide que no inserte una agenda con la misma hora y fecha*/
    SELECT COUNT (*) FROM REPORT_AGENDA_PROVEEDOR WHERE APROV_FECHA = NEW.aprov_fecha AND APROV_HORA = NEW.aprov_hora INTO :CANT;
    IF(CANT > 0) THEN
    exception  YA_EXISTE_EL_REGISTRO 'Ya existe un agendamiento con esa fecha y hora ' || new.aprov_fecha ;
  /*No permite null*/
  IF(NEW.APROV_ASISTENTES IS NULL) THEN
    NEW.APROV_ASISTENTES = 0;
end^

SET TERM ; ^

ALTER TABLE REPORT_AGENDA_PROVEEDOR
ADD APROV_ASECALIFICA VARCHAR(60);

UPDATE report_agenda_proveedor SET APROV_TERMINA = 'S' where APROV_TERMINA IS NULL OR APROV_TERMINA = 'N';

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/13';

ALTER TABLE report_agenda_cliente ALTER COLUMN agenda_facasocia TYPE VARCHAR(255);

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/18';

INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('AGENDA', 'AGENDA', 'PERMITIR TRAER UNA FACTURA O VARIAS', 'VARIAS', 'UNA,VARIAS', 'UNA: Permite seleccionar una factura nada mas en la opcion de facturas del clientes VARIAS:Permite seleccionar varias a traer desde la busqueda.');

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/19';



INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('TESORERIA', 'GASTOS', 'CLAVE PARA ELIMINAR GASTOS', '', '', 'Digite la clave que tendra la opcion de eliminar los gastos');
INSERT INTO REPORT_CONFIGURACION (MODULO_REPORT, OPCION_REPORT, NOMBRE_REPORT, VALOR_REPORT, POSIBLE_REPORT, DESCRIPCION_REPORT) VALUES ('TESORERIA', 'GASTOS', 'PREGUNTAR CLAVE PARA ANULAR GASTOS', 'SI', 'SI,NO', 'SI: Solicita clave de confirmación NO: Ignora la solicitud de clave');
ALTER TABLE REPORT_TIPO_USUARIO
ADD USUARIO_CAJA INTEGER;

ALTER TABLE REPORT_TIPO_USUARIO ALTER COLUMN USUARIO_CAJA
SET DEFAULT 0;

update REPORT_ACTUALIZACION
set FECHA_ACTUALIZA = '2022/05/31';

