Histórico da Página

Versões Suportadas:

• Oracle

• 19c (recomendado);

• Oracle 21c
  • Homologado a partir da Release 12.1.2412

Permissões TOTVS Agro Conector Client

• • • 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 ;

Permissões Produto

• • • 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 Conector Client requer a criação das seguintes tablespaces:

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

• Versões Suportadas:

• 
  
  • SQL Server 2019 (recomendado)

• • ;
  • SQL Server 2022;
    • Homologado a partir da Release 12.1.2412

Permissões TOTVS Agro Conector Client

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

    • GRANT CREATE TABLE ;

    • GRANT EXECUTE ;

• • • GRANT CONNECT ;

    • GRANT

• • • ALTER ;

    • GRANT CREATE SYNONYM ;

    • GRANT CREATE PROCEDURE ;

    • GRANT

• • • CREATE FUNCTION;

    • GRANT CREATE

• • • VIEW ;

    • GRANT REFERENCES ON SCHEMA::dbo;

Permissões Produto

• • • 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;