"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 would have to grant access to the role or person you desire to be able
to query the tables. Then just select:
- from mySchema.myTable where ...;
select * from yourSchema.yourTable where ...;
...
You can't join them because they are unrelated - you can join them, but it
wouldn't make sense.
Jim
Received on Thu Jun 10 2004 - 10:18:00 CDT
