Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SELECT from multiple schemas at ones?

SELECT from multiple schemas at ones?

From: Sten Westerback <sten.westerback_at_NO_SPAMnokia.com>
Date: Thu, 10 Jun 2004 14:16:04 GMT
Message-ID: <E2_xc.18696$k4.373403@news1.nokia.com>


Hi

We have a Oracle database server with a handful of schemas with the same set of tables (but different data). Each schema is accessible with different account&password.

Is it possible to make a query that would search all the tables with same name at ones? Or can you for instance make a view that joins the tables together with account and passwords included and if so.. is that secure?

Received on Thu Jun 10 2004 - 09:16:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US