Re: Need To See All Objects in Database

On 19 Aug, 00:49, grantschu..._at_gmail.com wrote:
> Hi,
>
> I am a SQL Server / PostgreSQL developer and am fairly new to Oracle.
> I'm starting out using Oracle XE 10g with the web based client that
> comes with it, and Oracle SQL Developer as my clients.
>
> I'm trying to figure out how to see all database objects (for all
> users) in the Object Browser, similar to what you see when logged in
> as 'sa' in SQL Server, or 'postgres' in PostgreSQL. I know there are
> the SYS and SYSTEM accounts, but I don't see other users' tables,
> views, etc when logged in under SYS or SYSTEM. I know that I can
> SELECT TABLE_NAME FROM ALL_TABLES; but that's not like seeing them in
> a tree view.
>
> The following Groups post was the closest thing I could find to an
> answer:
>
> http://groups.google.ca/group/comp.databases.oracle/browse_thread/thr...
>
> ... but this is from 2001, and the answer given is that it can't be
> done. Has anything changed since then?
>
> I have used a SQL Server 2000 DTS package to connect to Oracle with an
> Oracle username/password and was able to browse other users' objects
> that I had permissions to see, so there must be a way to do this.
>
> Any help would be greatly appreciated!
>
> Thanks,
> Grant Schulte

In SQL Developer, when connected as SYSTEM, you should be able to see objects belonging to other schemas by opening the "Other Users" tree under the "Connections" tab.

HTH -g Received on Tue Aug 19 2008 - 08:01:09 CDT