Histórico da Página

Versões Suportadas:

• Oracle 11g;
• Oracle 12c;
• Oracle 19c (recomendado);

Permissões TOTVS Agro PIMSConnector

• • • GRANT CONNECT ;
    • GRANT RESOURCE ;
    • GRANT UNLIMITED TABLESPACE ;
    • GRANT CREATE SYNONYM ;
    • GRANT CREATE VIEW ;
    • GRANT CREATE PROCEDURE ;
    • GRANT CREATE TRIGGER ;
    • GRANT CREATE SEQUENCE ; 
    • GRANT CREATE MATERIALIZED VIEW ;

    • GRANT CREATE ANY TABLE ;

    • GRANT ALTER ANY TABLE ;

    • GRANT SELECT ANY DICTIONARY ;

Tablespaces: TOTVS Agro PIMSConnector requer a criação das seguintes tablespaces:

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

• Versões Suportadas:

  
  
  • SQL Server 2016;
  • SQL Server 2017;
  • SQL Server 2019 (recomendado);

Permissões TOTVS Agro PIMSConnector

• • • GRANT SELECT, INSERT, UPDATE, DELETE ;

    • GRANT CREATE TABLE ;

    • GRANT EXECUTE ;

    • GRANT CONNECT ;

    • GRANT ALTER ;

    • GRANT VIEW DEFINITION ;

    • GRANT CREATE SYNONYM ;

    • GRANT CREATE PROCEDURE ;

    • GRANT CREATE FUNCTION;

    • GRANT CREATE VIEW ;

    • GRANT REFERENCES ON SCHEMA::dbo;
    • GRANT VIEW DEFINITION ON DATABASE;
    • GRANT VIEW DATABASE STATE;