Histórico da Página

CREATE USER {{DB_USUARIO_PI}} 

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;

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;

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;