Q: session current_user vs user_tables etc

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 Received on Wed Jan 25 2006 - 16:42:37 CST