Re: Q: session current_user vs user_tables etc
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Thu, 26 Jan 2006 13:05:00 -0800
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@xxxxxxxxxxxxxxxx (replace x with u to respond) .
- References:
- Q: session current_user vs user_tables etc
- From: Malcolm Dew-Jones
- Q: session current_user vs user_tables etc
- Prev by Date: Re: what's wrong with this query?
- Next by Date: pivot/transform in Oracle
- Previous by thread: Re: session current_user vs user_tables etc
- Next by thread: any software for developer
- Index(es):
Relevant Pages
|
|
