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 -> Re: Q: session current_user vs user_tables etc

Re: Q: session current_user vs user_tables etc

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 26 Jan 2006 13:05:00 -0800
Message-ID: <1138309498.36827@jetspin.drizzle.com>


Malcolm Dew-Jones wrote:
> I can use
> alter session set current_schema=xxx
>
> and then queries such as
> select * from table_name_no_schema
> will find the table in the xxx schema, just as if I was xxx to begin with.
>
> However, if I do queries such as
> select * from user_tables
> then I see my own tables, not the xxx tables (which is understandable, I'm
> not questioning that).
>
> My question is, are there any views similar to the user_* views but to
> access things within the current_schema, or must I use the all_* views and
> filter everything by sys_context('USERENV','CURRENT_SCHEMA') ?
>
> Feedback appreciated.
>
> malcolm

Not aware of any views that do what you are asking.

But this is a great time to remind people to check out user_all_tables.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jan 26 2006 - 15:05:00 CST

Original text of this message

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