O TOTVS Agro Indústria requer a criação das seguintes tablespaces:

  • Tablespace de Dados: PIMS_DATA
  • Tablespace de Índice: PIMS_INDX


CREATE TABLESPACE PIMS_DATA DATAFILE '/u01/oradata/orcl/PIMS_DATA.ORA' SIZE 20G;

CREATE TABLESPACE PIMS_INDX DATAFILE '/u01/oradata/orcl/PIMS_INDEX.ORA' SIZE 20G;


Criação de Owner e Atribuição de Permissões

A TOTVS Agro Indústria precisará de dois Owners: um responsável pelo aplicativo MI (Manutenção Industrial) e outro pelo PI (Processo Industrial). 

CREATE USER {{DB_USUARIO_MI}} IDENTIFIED BY "{{DB_SENHA_MI}}" DEFAULT TABLESPACE PIMS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;  

GRANT CONNECT                    TO {{DB_USUARIO_MI}};
GRANT "RESOURCE                  TO {{DB_USUARIO_MI}};
GRANT UNLIMITED TABLESPACE       TO {{DB_USUARIO_MI}};
GRANT DEBUG CONNECT SESSION      TO {{DB_USUARIO_MI}};
GRANT DEBUG ANY PROCEDURE        TO {{DB_USUARIO_MI}};  
GRANT CREATE SYNONYM             TO {{DB_USUARIO_MI}};
GRANT CREATE VIEW                TO {{DB_USUARIO_MI}};
GRANT CREATE PROCEDURE           TO {{DB_USUARIO_MI}}; 
GRANT CREATE TRIGGER             TO {{DB_USUARIO_MI}};
GRANT CREATE SEQUENCE            TO {{DB_USUARIO_MI}}; 
GRANT CREATE MATERIALIZED VIEW   TO {{DB_USUARIO_MI}};
GRANT UNLIMITED TABLESPACE		 TO {{DB_USUARIO_MI}};

ALTER USER {{DB_USUARIO_MI}} QUOTA UNLIMITED ON PIMS_DATA;
ALTER USER {{DB_USUARIO_MI}} QUOTA UNLIMITED ON PIMS_INDX; 
CREATE USER {{DB_USUARIO_PI}} IDENTIFIED BY "{{DB_SENHA_PI}}" DEFAULT TABLESPACE PIMS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;  

GRANT CONNECT                    TO {{DB_USUARIO_PI}};
GRANT "RESOURCE                  TO {{DB_USUARIO_PI}};
GRANT UNLIMITED TABLESPACE       TO {{DB_USUARIO_PI}};
GRANT DEBUG CONNECT SESSION      TO {{DB_USUARIO_PI}};
GRANT DEBUG ANY PROCEDURE        TO {{DB_USUARIO_PI}};  
GRANT CREATE SYNONYM             TO {{DB_USUARIO_PI}};
GRANT CREATE VIEW                TO {{DB_USUARIO_PI}};
GRANT CREATE PROCEDURE           TO {{DB_USUARIO_PI}}; 
GRANT CREATE TRIGGER             TO {{DB_USUARIO_PI}};
GRANT CREATE SEQUENCE            TO {{DB_USUARIO_PI}}; 
GRANT CREATE MATERIALIZED VIEW   TO {{DB_USUARIO_PI}};
GRANT UNLIMITED TABLESPACE		 TO {{DB_USUARIO_PI}};

ALTER USER {{DB_USUARIO_PI}} QUOTA UNLIMITED ON PIMS_DATA;
ALTER USER {{DB_USUARIO_PI}} QUOTA UNLIMITED ON PIMS_INDX;


O TOTVS Agro Indústria necessita de um Owner, que deverá ser aplicado um trigger de logon para o Owner do TOTVS Agro Bioenergia. Esse usuário deverá possuir as permissões listadas abaixo. O mesmo Owner será utilizado para ambas as aplicações: MI (Manutenção Industrial) e PI (Processo Industrial)


CREATE USER {{DB_USUARIO_INDUSTRIA_INTEGRACAO}} IDENTIFIED BY "DB_SENHA_INDUSTRIA_INTEGRACAO"  DEFAULT TABLESPACE PIMS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;  

GRANT CONNECT                       TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT RESOURCE                      TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT UNLIMITED TABLESPACE          TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE SYNONYM                TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE VIEW                   TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE PROCEDURE              TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE TRIGGER                TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE SEQUENCE               TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}}; 
GRANT CREATE MATERIALIZED VIEW      TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE ANY TABLE              TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT ALTER ANY TABLE               TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT INSERT ANY TABLE              TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT UPDATE ANY TABLE              TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT DELETE ANY TABLE              TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT SELECT ANY TABLE              TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE ANY TRIGGER            TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
GRANT CREATE ANY SEQUENCE           TO {{DB_USUARIO_INDUSTRIA_INTEGRACAO}};
 
 
ALTER USER {{DB_USUARIO_INDUSTRIA_INTEGRACAO}} QUOTA UNLIMITED      ON PIMS_DATA;
ALTER USER {{DB_USUARIO_INDUSTRIA_INTEGRACAO}} QUOTA UNLIMITED      ON PIMS_INDX;  





CREATE OR REPLACE TRIGGER TG_LOGON_OWNER_INTEGRACAO_INDUSTRIA
AFTER LOGON ON DATABASE
BEGIN
    IF SYS_CONTEXT('USERENV', 'SESSION_USER') = 'DB_USUARIO_INDUSTRIA_INTEGRACAO' THEN
        EXECUTE IMMEDIATE 'ALTER SESSION SET CURRENT_SCHEMA = OWNER_BIOENERGIA';
    END IF;
END;



O TOTVS Agro Indústria precisará criar os sinônimos para a base do TOTVS Agro Bioenergia, pois o Indústria também utiliza essas tabelas de forma compartilhada.


  • MI  - Manutenção Industrial
    • PARAMETROS         
    • PMMENSAGENS         
    • PMAUTLOG             
    • MUNICIPIOS         
    • PMUSUARIOS         
    • CTA_CSTO             
    • PMINDISPAPL         
    • PMAUTORIDADES     
    • PMINSTANCIAS         
    • EMPRESAS             
    • FUNCIONARS         
    • PMOBJETOS         
    • PMGRUPOS             
    • PMUSUARIOS_INST     
    • PMSESSOES           
    • PMAPLICATIVOS     
    • PMCENTRAL_AJUDA     
    • FLUIG_IDP_CONF     
    • PM_SESSAO_FLUIG_IDP



CREATE OR REPLACE SYNONYM PARAMETROS 			FOR ${OWNER_BIOENERGIA}.PARAMETROS;
CREATE OR REPLACE SYNONYM PMMENSAGENS 			FOR ${OWNER_BIOENERGIA}.PMMENSAGENS;
CREATE OR REPLACE SYNONYM PMAUTLOG 				FOR ${OWNER_BIOENERGIA}.PMAUTLOG;
CREATE OR REPLACE SYNONYM MUNICIPIOS 			FOR ${OWNER_BIOENERGIA}.MUNICIPIOS;
CREATE OR REPLACE SYNONYM PMUSUARIOS 			FOR ${OWNER_BIOENERGIA}.PMUSUARIOS;
CREATE OR REPLACE SYNONYM CTA_CSTO 				FOR ${OWNER_BIOENERGIA}.CTA_CSTO;
CREATE OR REPLACE SYNONYM PMINDISPAPL 			FOR ${OWNER_BIOENERGIA}.PMINDISPAPL;
CREATE OR REPLACE SYNONYM PMAUTORIDADES 		FOR ${OWNER_BIOENERGIA}.PMAUTORIDADES;
CREATE OR REPLACE SYNONYM PMINSTANCIAS 			FOR ${OWNER_BIOENERGIA}.PMINSTANCIAS;
CREATE OR REPLACE SYNONYM EMPRESAS 				FOR ${OWNER_BIOENERGIA}.EMPRESAS;
CREATE OR REPLACE SYNONYM FUNCIONARS 			FOR ${OWNER_BIOENERGIA}.FUNCIONARS;
CREATE OR REPLACE SYNONYM PMOBJETOS 			FOR ${OWNER_BIOENERGIA}.PMOBJETOS;
CREATE OR REPLACE SYNONYM PMGRUPOS 				FOR ${OWNER_BIOENERGIA}.PMGRUPOS;
CREATE OR REPLACE SYNONYM PMUSUARIOS_INST 		FOR ${OWNER_BIOENERGIA}.PMUSUARIOS_INST;
CREATE OR REPLACE SYNONYM PMSESSOES 	  		FOR ${OWNER_BIOENERGIA}.PMSESSOES;
CREATE OR REPLACE SYNONYM PMAPLICATIVOS 		FOR ${OWNER_BIOENERGIA}.PMAPLICATIVOS;
CREATE OR REPLACE SYNONYM PMCENTRAL_AJUDA 		FOR ${OWNER_BIOENERGIA}.PMCENTRAL_AJUDA;
CREATE OR REPLACE SYNONYM FLUIG_IDP_CONF 		FOR ${OWNER_BIOENERGIA}.FLUIG_IDP_CONF;
CREATE OR REPLACE SYNONYM PM_SESSAO_FLUIG_IDP	FOR ${OWNER_BIOENERGIA}.PM_SESSAO_FLUIG_IDP;
CREATE OR REPLACE SYNONYM PM_RESTR_TABELAS  	FOR ${OWNER_BIOENERGIA}.PM_RESTR_TABELAS;



  • PI - Processo Industrial 
    • PMMENSAGENS              
    • LT_UNIDIND_META          
    • LT_MOTIVOS_RESP          
    • PMINDISPAPL             
    • PMOBJETOS              
    • EMPRESAS              
    • PMAUTLOG              
    • LT_MOTIVOS              
    • PMUSUARIOS              
    • PMSESSOES              
    • PMCENTRAL_AJUDA          
    • CAD_PRODUTO              
    • LT_RESP_PARADAS          
    • PMUSUARIOS_INST          
    • CTA_CSTO              
    • UNIDIND                  
    • PARAMETROS              
    • PMAUTORIDADES          
    • FLUIG_IDP_CONF          
    • LT_UNIDIND              
    • LT_UNIDIND_ROTMOENDA  
    • PMAPLICATIVOS          
    • PMGRUPOS              
    • PMINSTANCIAS          
    • PM_SESSAO_FLUIG_IDP      
    • PM_SESSAO_FLUIG_IDP      
    • LOG_PARAM              



CREATE OR REPLACE SYNONYM PMMENSAGENS  			FOR ${OWNER_BIOENERGIA}.PMMENSAGENS;
CREATE OR REPLACE SYNONYM LT_UNIDIND_META  		FOR ${OWNER_BIOENERGIA}.LT_UNIDIND_META;
CREATE OR REPLACE SYNONYM LT_MOTIVOS_RESP  		FOR ${OWNER_BIOENERGIA}.LT_MOTIVOS_RESP;
CREATE OR REPLACE SYNONYM PMINDISPAPL 			FOR ${OWNER_BIOENERGIA}.PMINDISPAPL;
CREATE OR REPLACE SYNONYM PMOBJETOS  			FOR ${OWNER_BIOENERGIA}.PMOBJETOS;
CREATE OR REPLACE SYNONYM EMPRESAS  			FOR ${OWNER_BIOENERGIA}.EMPRESAS;
CREATE OR REPLACE SYNONYM PMAUTLOG  			FOR ${OWNER_BIOENERGIA}.PMAUTLOG;
CREATE OR REPLACE SYNONYM LT_MOTIVOS  			FOR ${OWNER_BIOENERGIA}.LT_MOTIVOS;
CREATE OR REPLACE SYNONYM PMUSUARIOS  			FOR ${OWNER_BIOENERGIA}.PMUSUARIOS;
CREATE OR REPLACE SYNONYM PMSESSOES  			FOR ${OWNER_BIOENERGIA}.PMSESSOES;
CREATE OR REPLACE SYNONYM PMCENTRAL_AJUDA  		FOR ${OWNER_BIOENERGIA}.PMCENTRAL_AJUDA;
CREATE OR REPLACE SYNONYM CAD_PRODUTO  			FOR ${OWNER_BIOENERGIA}.CAD_PRODUTO;
CREATE OR REPLACE SYNONYM LT_RESP_PARADAS  		FOR ${OWNER_BIOENERGIA}.LT_RESP_PARADAS;
CREATE OR REPLACE SYNONYM PMUSUARIOS_INST  		FOR ${OWNER_BIOENERGIA}.PMUSUARIOS_INST;
CREATE OR REPLACE SYNONYM CTA_CSTO  			FOR ${OWNER_BIOENERGIA}.CTA_CSTO;
CREATE OR REPLACE SYNONYM UNIDIND  				FOR ${OWNER_BIOENERGIA}.UNIDIND;
CREATE OR REPLACE SYNONYM PARAMETROS  			FOR ${OWNER_BIOENERGIA}.PARAMETROS;
CREATE OR REPLACE SYNONYM PMAUTORIDADES  		FOR ${OWNER_BIOENERGIA}.PMAUTORIDADES;
CREATE OR REPLACE SYNONYM FLUIG_IDP_CONF  		FOR ${OWNER_BIOENERGIA}.FLUIG_IDP_CONF;
CREATE OR REPLACE SYNONYM LT_UNIDIND  			FOR ${OWNER_BIOENERGIA}.LT_UNIDIND;
CREATE OR REPLACE SYNONYM LT_UNIDIND_ROTMOENDA  FOR ${OWNER_BIOENERGIA}.LT_UNIDIND_ROTMOENDA;
CREATE OR REPLACE SYNONYM PMAPLICATIVOS  		FOR ${OWNER_BIOENERGIA}.PMAPLICATIVOS;
CREATE OR REPLACE SYNONYM PMGRUPOS  			FOR ${OWNER_BIOENERGIA}.PMGRUPOS;
CREATE OR REPLACE SYNONYM PMINSTANCIAS  		FOR ${OWNER_BIOENERGIA}.PMINSTANCIAS;
CREATE OR REPLACE SYNONYM PM_SESSAO_FLUIG_IDP  	FOR ${OWNER_BIOENERGIA}.PM_SESSAO_FLUIG_IDP;
CREATE OR REPLACE SYNONYM PM_SESSAO_FLUIG_IDP  	FOR ${OWNER_BIOENERGIA}.PM_SESSAO_FLUIG_IDP;
CREATE OR REPLACE SYNONYM LOG_PARAM  			FOR ${OWNER_BIOENERGIA}.LOG_PARAM;