Re: Users relationship to a schema...or Why can't I "see" things?

"SET SCHEMA" is not available prior to 8i.

you do know that in the TOAD Schema browswer window, you can select a different "owner" from the drop down list box near the top of the window.

if that still doesn't work, you could try enabling the use of the DBA_ catalog views:

connected as system:

GRANT SELECT_CATALOG_ROLE TO newuser ;

in TOAD options window, select option

"check for access to dba_ views on startup"

restart TOAD.

HTH "David Stidham" <DStidham_at_msn.com> wrote in message news:#$CdFqP7AHA.274_at_cpmsnbbsa07...
> Thank you all for your assistance. You've confirmed what I have been
> "seeing" in my attempts to "see" those tables and other objects owned by
 the
> DATA_OWNER user.
>
> There is one other way to avoid using fully qualified names that no one
 has
> mentioned;
> ALTER SESSION SET SCHEMA=new_schema_name;
>
> This allows the alternate user to then reference the tables and objects of
> the new_schema_name without fully qualifying them or having to create
 public
> synonyms for them. Thought I would share that tidbit in the event that
> there were any readers that were unaware of this information.
>
> David
>
>
>
Received on Tue Jun 05 2001 - 01:52:01 CDT