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 -> Re: SELECT from multiple schemas at ones?

Re: SELECT from multiple schemas at ones?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 10 Jun 2004 15:18:00 GMT
Message-ID: <IY_xc.656$zz.219@attbi_s04>

"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:

Received on Thu Jun 10 2004 - 10:18:00 CDT

Original text of this message

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