-- Server : localhost:7707
-- Inicio gsw00_nano
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Empresa;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Vendedor;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Articulo;
DROP TABLE IF EXISTS gsw00_nano.Grf_Rubros;
DROP TABLE IF EXISTS gsw00_nano.TMP_Insumos;
DROP TABLE IF EXISTS gsw00_nano.CobroConfTrfBco;
DROP TABLE IF EXISTS gsw00_nano.CobroConfCheques;
DROP TABLE IF EXISTS gsw00_nano.CobroConfTarjetas;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetIva;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetGan;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetIB;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetSUSS;
CREATE TABLE gsw00_nano.Grf_x_Empresa(Col1 INT);
CREATE TABLE gsw00_nano.Grf_x_Vendedor(Col1 INT);
CREATE TABLE gsw00_nano.Grf_x_Articulo(Col1 INT);
CREATE TABLE gsw00_nano.Grf_rubros(Col1 INT);
CREATE TABLE gsw00_nano.TMP_Insumos(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfTrfBco(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfCheques(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfTarjetas(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfRetIva(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfRetGan(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfRetIB(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfRetSUSS(Col1 INT);
CREATE TABLE gsw00_nano.CobroConfNotasCredito(Col1 INT);
CREATE TABLE gsw00_nano.CompTMP(Col1 INT);
CREATE TABLE gsw00_nano.ListasPreciosEspecialesArticulosTMP(Col1 INT);
CREATE USER 'gsw00_nano' IDENTIFIED BY 'Z3N3MTFebGNtbG==';
GRANT SELECT                  ON gsw00_nano.*                      TO gsw00_nano;
GRANT INSERT                  ON gsw00_nano.*                      TO gsw00_nano;
GRANT UPDATE                  ON gsw00_nano.*                      TO gsw00_nano;
GRANT EXECUTE                 ON gsw00_nano.*                      TO gsw00_nano;
GRANT CREATE TEMPORARY TABLES ON gsw00_nano.*                      TO gsw00_nano;
GRANT LOCK TABLES             ON gsw00_nano.*                      TO gsw00_nano;
GRANT FILE                    ON *.*                           TO gsw00_nano;
GRANT CREATE                  ON gsw00_nano.Grf_x_Empresa  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Grf_x_Empresa  TO gsw00_nano;
GRANT DROP                    ON gsw00_nano.Grf_x_Empresa  TO gsw00_nano;
GRANT CREATE                  ON gsw00_nano.Grf_x_Vendedor  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Grf_x_Vendedor  TO gsw00_nano;
GRANT DROP                    ON gsw00_nano.Grf_x_Vendedor  TO gsw00_nano;
GRANT CREATE                  ON gsw00_nano.Grf_x_Articulo  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Grf_x_Articulo  TO gsw00_nano;
GRANT DROP                    ON gsw00_nano.Grf_x_Articulo  TO gsw00_nano;
GRANT CREATE                  ON gsw00_nano.Grf_rubros  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Grf_rubros  TO gsw00_nano;
GRANT DROP                    ON gsw00_nano.Grf_rubros  TO gsw00_nano;
GRANT CREATE                  ON gsw00_nano.TMP_Insumos  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.TMP_Insumos  TO gsw00_nano;
GRANT DROP                    ON gsw00_nano.TMP_Insumos  TO gsw00_nano;
GRANT ALTER                   ON gsw00_nano.TMP_Insumos  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfTrfBco   TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfCheques  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfTarjetas TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfRetIva   TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfRetGan   TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfRetIB    TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfRetSUSS  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CobroConfNotasCredito TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Tmp_Comprobante        TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Tmp_comprobantedetalle TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Tmp_CompOtrosTributos  TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.Tmp_CompExpImp         TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.TMP_CompDetalleLotes   TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.TMP_CompDetalleLotesSeries TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.TMP_CompDetalleVehiculos TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CompTMP TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.CalendarioEventos TO gsw00_nano;
GRANT DELETE                  ON gsw00_nano.ListasPreciosEspecialesArticulosTMP TO gsw00_nano;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Empresa;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Vendedor;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Articulo;
DROP TABLE IF EXISTS gsw00_nano.Grf_Rubros;
DROP TABLE IF EXISTS gsw00_nano.TMP_Insumos;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Empresa;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Vendedor;
DROP TABLE IF EXISTS gsw00_nano.Grf_x_Articulo;
DROP TABLE IF EXISTS gsw00_nano.Grf_Rubros;
DROP TABLE IF EXISTS gsw00_nano.TMP_Insumos;
DROP TABLE IF EXISTS gsw00_nano.CobroConfTrfBco;
DROP TABLE IF EXISTS gsw00_nano.CobroConfCheques;
DROP TABLE IF EXISTS gsw00_nano.CobroConfTarjetas;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetIva;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetGan;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetIB;
DROP TABLE IF EXISTS gsw00_nano.CobroConfRetSUSS;
DROP TABLE IF EXISTS gsw00_nano.CobroConfNotasCredito;
DROP TABLE IF EXISTS gsw00_nano.CompTMP;
GRANT SELECT                  ON pstables.* TO gsw00_nano;
GRANT EXECUTE                 ON pstables.* TO gsw00_nano;
GRANT LOCK TABLES             ON pstables.* TO gsw00_nano;
-- Fin gsw00_nano

