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

Home -> Community -> Usenet -> c.d.o.server -> 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