Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: session current_user vs user_tables etc
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