Histórico da Página
...
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 | ||
|
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:
...
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');
Nota | ||
---|---|---|
| ||
O comando SQL acima deverá ser executado com o usuário "userid" criado nos passos anteriores. |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas