Histórico da Página
...
- userid: Nome do usuário criado anteriormente;
Por fim, será Neste momento é necessário executar um comando SQL no os procedimentos SQL abaixo com o usuário userid no banco de dados a ser usado para o fluig:
Bloco de código |
---|
CREATE VIEW ALL_OBJECTS AS SELECT * FROM SYS.ALL_OBJECTS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_SYNONYMS AS SELECT * FROM SYS.ALL_SYNONYMS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_SEQUENCES AS SELECT * FROM SYS.ALL_SEQUENCES WHERE SEQUENCE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_CONSTRAINTS AS SELECT * FROM SYS.ALL_CONSTRAINTS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_CONS_COLUMNS AS SELECT * FROM SYS.ALL_CONS_COLUMNS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_INDEXES AS SELECT * FROM SYS.ALL_INDEXES WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_IND_COLUMNS AS SELECT * FROM SYS.ALL_IND_COLUMNS WHERE TABLE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_TABLES AS SELECT * FROM SYS.ALL_TABLES WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_TAB_COLUMNS AS SELECT * FROM SYS.ALL_TAB_COLUMNS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); |
...
Nota | ||
---|---|---|
| ||
É imprescindível conectar no banco de dados com o usuário userid para a execução dos procedimentos acima a fim de garantir o isolamento e integridade da operação. |
Oracle 12c:
Caso seja utilizado Oracle 12c ou superior é necessário alterar o arquivo <INSTALL_FLUIG>\jboss\bin\standalone.conf.bat(standalone.conf em ambientes Linux) e incluir a seguinte linha:
...
Nota | ||
---|---|---|
| ||
NLS (National Language Support) é utilizado para definir datas, números, moeda e configurações de idioma. O NLS_CHARACTERSET para o Fluig é AL32UTF8.
|
...
...
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
...
...
SELECT * FROM SYS.ALL_SYNONYMS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
CREATE VIEW ALL_SEQUENCES AS
SELECT * FROM SYS.ALL_SEQUENCES
WHERE SEQUENCE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
CREATE VIEW ALL_CONSTRAINTS AS
SELECT * FROM SYS.ALL_CONSTRAINTS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
CREATE VIEW ALL_CONS_COLUMNS AS
SELECT * FROM SYS.ALL_CONS_COLUMNS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
CREATE VIEW ALL_INDEXES AS
SELECT * FROM SYS.ALL_INDEXES
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
CREATE VIEW ALL_IND_COLUMNS AS
SELECT * FROM SYS.ALL_IND_COLUMNS
WHERE TABLE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
|
CREATE VIEW ALL_TABLES AS
SELECT * FROM SYS.ALL_TABLES
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
CREATE VIEW ALL_TAB_COLUMNS AS
SELECT * FROM SYS.ALL_TAB_COLUMNS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');
...
title | Importante |
---|
...