A versão Express Edition (Oracle XE) não é homologada para os sistemas da vertical Agrotitan, então a mesma não pode ser usada para os produtos desta vertical. Em caso de dúvida procure apoio da equipe técnica ou de suporte da Viasoft.

Está documentação está direcionada a instalação do Oracle para testes internos. A instalação em cliente fica a cargo do DBA da empresa.

/************************************/
/** DROP USERS **/DROP USER VIASOFT CASCADE;
/** CREATE USERS **/ CREATE USER VIASOFT /*NOME DO USUARIO */ IDENTIFIED BY VIASOFT /*SENHA */ DEFAULT TABLESPACE VS_USER; /*TABLE PADRAO */
/** PRIVILÉGIOS **/GRANT DBA TO VIASOFT; GRANT CREATE SESSION TO VIASOFT;
/** TYPE USERS **/GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFT;
/************************************/
DROP USER VIASOFTSYS CASCADE;
CREATE USER VIASOFTSYS IDENTIFIED BY VIASOFTSYS DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTSYS;
GRANT CREATE SESSION TO VIASOFTSYS;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTSYS;
/************************************/
DROP USER VIASOFTCTB CASCADE;
CREATE USER VIASOFTCTB IDENTIFIED BY VIASOFTCTB DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTCTB;
GRANT CREATE SESSION TO VIASOFTCTB;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTCTB;
/************************************/
DROP USER VIASOFTFISCAL CASCADE;
CREATE USER VIASOFTFISCAL IDENTIFIED BY VIASOFTFISCAL DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTFISCAL;
GRANT CREATE SESSION TO VIASOFTFISCAL;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTFISCAL;
/************************************/
DROP USER VIASOFTBASE CASCADE;
CREATE USER VIASOFTBASE IDENTIFIED BY VIASOFTBASE DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTBASE;
GRANT CREATE SESSION TO VIASOFTBASE;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTBASE;
/************************************/
DROP USER VIASOFTCP CASCADE;
CREATE USER VIASOFTCP IDENTIFIED BY VIASOFTCP DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTCP;
GRANT CREATE SESSION TO VIASOFTCP;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTCP;
/************************************/
DROP USER VIASOFTRH CASCADE;
CREATE USER VIASOFTRH IDENTIFIED BY VIASOFTRH DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTRH;
GRANT CREATE SESSION TO VIASOFTRH;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTRH;
/************************************/
DROP USER VIASOFTMCP CASCADE;
CREATE USER VIASOFTMCP IDENTIFIED BY VIASOFTMCP DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTMCP;
GRANT CREATE SESSION TO VIASOFTMCP;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTMCP;
/************************************/
DROP USER VIASOFTLOGISTICA CASCADE;
CREATE USER VIASOFTLOGISTICA IDENTIFIED BY VIASOFTLOGISTICA DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTLOGISTICA;
GRANT CREATE SESSION TO VIASOFTLOGISTICA;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTLOGISTICA;
/************************************/
DROP USER VIASOFTFIN CASCADE;
CREATE USER VIASOFTFIN IDENTIFIED BY VIASOFTFIN DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTFIN;
GRANT CREATE SESSION TO VIASOFTFIN;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTFIN;
/************************************/
DROP USER VIASOFTGP CASCADE;
CREATE USER VIASOFTGP IDENTIFIED BY VIASOFTGP DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTGP;
GRANT CREATE SESSION TO VIASOFTGP;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTGP;
/************************************/
DROP USER VIASOFTMERC CASCADE;
CREATE USER VIASOFTMERC IDENTIFIED BY VIASOFTMERC DEFAULT TABLESPACE VS_USER;
GRANT DBA TO VIASOFTMERC;
GRANT CREATE SESSION TO VIASOFTMERC;
GRANT EXECUTE ON SYS.UTL_RECOMP TO VIASOFTMERC;

GRANT CREATE SEQUENCE TO VIASOFT;

COMMIT WORK;