Histórico da Página

CREATE USER {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}} IDENTIFIED BY "DB_SENHA_PIMS_SERVER_INTEGRACAO"  DEFAULT TABLESPACE PIMS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; 
 
GRANT CONNECT

                       TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT RESOURCE

                      TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT UNLIMITED TABLESPACE          TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT

 CREATE SYNONYM                TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT

 CREATE VIEW                   TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT

 CREATE PROCEDURE              TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT

 CREATE TRIGGER                TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT CREATE

 SEQUENCE               TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}}; 
GRANT CREATE MATERIALIZED VIEW      TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT CREATE ANY

 TABLE              TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT 

ALTER ANY

 TABLE               TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT 

INSERT ANY 

TABLE              TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT 

UPDATE ANY

 TABLE              TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT 

DELETE ANY

 TABLE              TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT 

SELECT ANY

 TABLE              TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT 

CREATE ANY TRIGGER    

TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
GRANT

 CREATE ANY SEQUENCE           TO {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}};
 
 
ALTER USER {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}} QUOTA UNLIMITED   

ON PIMS_DATA;
ALTER USER {{DB_USUARIO_PIMS_SERVER_INTEGRACAO}} QUOTA UNLIMITED    

ON PIMS_INDX; 

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