O TOTVS Agro Conector Connector Client requer a criação das seguintes tablespaces:- Tablespace de Dados: PIMS_DATA
- Tablespace de Índice: PIMS_INDX
| Bloco de código |
|---|
| language | sql |
|---|
| title | Tablespace |
|---|
| CREATE TABLESPACE PIMS_DATA DATAFILE '/u01/oradata/orcl/PIMS_DATA.ORA' SIZE 20G;
CREATE TABLESPACE PIMS_INDX DATAFILE '/u01/oradata/orcl/PIMS_INDEX.ORA' SIZE 20G; |
Criação de Owner e Atribuição de Permissões
| Bloco de código |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | Criação do Usuário / Owner- TOTVS Agro Conector Connector Client |
|---|
| CREATE USER {{DB_USUARIO_TCONNECTOR_CLIENT}} IDENTIFIED BY "{{DB_SENHA_TCONNECTOR_CLIENT}}" DEFAULT TABLESPACE PIMS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT "RESOURCE TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT UNLIMITED TABLESPACE TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT DEBUG CONNECT SESSION TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT DEBUG ANY PROCEDURE TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT CREATE SYNONYM TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT CREATE VIEW TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT CREATE PROCEDURE TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT CREATE TRIGGER TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT CREATE SEQUENCE TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT CREATE MATERIALIZED VIEW TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
GRANT UNLIMITED TABLESPACE TO {{DB_USUARIO_TCONNECTOR_CLIENT}};
ALTER USER {{DB_USUARIO_TCONNECTOR_CLIENT}} QUOTA UNLIMITED ON PIMS_DATA;
ALTER USER {{DB_USUARIO_TCONNECTOR_CLIENT}} QUOTA UNLIMITED ON PIMS_INDX; |
O TOTVS Agro Connector Client necessita de um owner, que deverá ser aplicado um trigger de logon para o Owner do TOTVS Agro Bioenergia. Esse usuário deverá possuir as permissões listadas abaixo.
| Bloco de código |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | Criação do Usuário / Owner- Smart Viewde Integração do TOTVS Connector Client |
|---|
| CREATE USER {{DB_USUARIO_SMARTTCONNECTOR_CLIENT_VIEWINTEGRACAO}} IDENTIFIED BY "{{DB_SENHA_SMART_VIEW}}TCONNECTOR_CLIENT_INTEGRACAO" DEFAULT DEFAULT TABLESPACE PIMS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO TO {{DB_USUARIO_TCONNECTOR_SMARTCLIENT_VIEWINTEGRACAO}};
GRANT "RESOURCE TO TO {{DB_USUARIO_TCONNECTOR_SMARTCLIENT_VIEWINTEGRACAO}};
GRANT UNLIMITED TABLESPACE TO {{DB_USUARIO_SMART_VIEW}};
GRANT DEBUG CONNECT SESSION TO TO {{DB_USUARIO_SMARTTCONNECTOR_CLIENT_VIEWINTEGRACAO}};
GRANT DEBUGCREATE ANYSYNONYM PROCEDURE TO {{DB_USUARIO_SMART_VIEW}};
GRANT CREATE SYNONYM TO {{DB_USUARIO_SMARTTCONNECTOR_CLIENT_VIEWINTEGRACAO}};
GRANT CREATE VIEW TO TO {{DB_USUARIO_SMARTTCONNECTOR_CLIENT_VIEWINTEGRACAO}};
GRANT CREATE PROCEDURE TO {{DB_USUARIO_SMARTTCONNECTOR_CLIENT_VIEWINTEGRACAO}};
GRANT CREATE TRIGGER TO {{DB_USUARIO_TCONNECTOR_SMARTCLIENT_VIEWINTEGRACAO}};
GRANT CREATE SEQUENCE TO TO {{DB_USUARIO_SMARTTCONNECTOR_CLIENT_VIEWINTEGRACAO}};
GRANT CREATE MATERIALIZED VIEW TO {{DB_USUARIO_SMARTTCONNECTOR_CLIENT_VIEWINTEGRACAO}};
GRANT UNLIMITEDCREATE TABLESPACE ANY TO {{DB_USUARIO_SMART_VIEW}};
ALTER USER {{DB_USUARIO_SMART_VIEW}} QUOTA UNLIMITED ON PIMS_DATA;
ALTER USER {{DB_USUARIO_SMART_VIEW}} QUOTA UNLIMITED ON PIMS_INDX; |
O TOTVS Agro API Hub necessita de um owner, que deverá ser aplicado um trigger de logon para o Owner do TOTVS Agro Bioenergia. Esse usuário deverá possuir as permissões listadas abaixo. | Bloco de código |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | Criação do Usuário de Integração do Smart View |
|---|
| CREATE USERTABLE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}} IDENTIFIED BY "DB_SENHA_SMART_VIEW_INTEGRACAO" DEFAULT TABLESPACE PIMS_DATA TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECTALTER ANY TABLE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT RESOURCEINSERT ANY TABLE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT UNLIMITED TABLESPACE UPDATE ANY TABLE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATEDELETE SYNONYMANY TABLE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATESELECT VIEW ANY TABLE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATE PROCEDUREANY TRIGGER TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATEGRANT TRIGGERANY OBJECT PRIVILEGE TO TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATE SEQUENCEANY TRIGGER TO TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATE MATERIALIZEDANY VIEWSEQUENCE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATE ANY TABLEINDEX TO TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT ALTERDROP ANY TABLETRIGGER TO TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT INSERTDROP ANY TABLESEQUENCE TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT UPDATEDROP ANY TABLEINDEX TO TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT DELETESELECT ANYON TABLEDBA_CONSTRAINTS TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT SELECT ANY TABLE ON DBA_CONS_COLUMNS TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATESELECT ANY TRIGGERON DBA_TAB_COLS TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATESELECT ANYON SEQUENCEDBA_VIEWS TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
GRANT CREATESELECT ANY INDEX ON DBA_TAB_COLUMNS TO {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}};
ALTER USER {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}} QUOTA UNLIMITED ON PIMS_DATA;
ALTER USER {{DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO}} QUOTA UNLIMITED ON PIMS_INDX;
|
| Bloco de código |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | Criação da Trigger de Logon |
|---|
| CREATE OR REPLACE TRIGGER TG_LOGON_OWNER_INTEGRACAOTCONNECTOR_SMARTCLIENT_VIEW
INTEGRACAO AFTER AFTER LOGON ON DATABASE
BEGIN
IF SYS_CONTEXT('USERENV', 'SESSION_USER') = 'DB_USUARIO_SMARTTCONNECTOR_VIEWCLIENT_INTEGRACAO' THEN
EXECUTE IMMEDIATE 'ALTER SESSION SET CURRENT_SCHEMA = OWNER_BIOENERGIA';
END IF;
END; |
| 