"Sten Westerback" <sten.westerback_at_NO_SPAMnokia.com> wrote in message news:<E2_xc.18696$k4.373403_at_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?
>
> - Sten
You can do it with synonyms (i.e. CREATE SYNONYM TABLE1A FOR SCHEMA1.TABLE1 and
CREATE SYNONYM TABLE1B FOR SCHEMA2.TABLE1 - you can then join TABLE1A and TABLE1B).
Received on Thu Jun 10 2004 - 14:35:40 CDT
