View Schemas in Toad9.0.1.8 Vs Oracle Sql Developer1.2.1.

Posted on 2007-10-12
Last Modified: 2008-01-09
Suppose I have a database db9i

connected using: user1/pass@db9i

while in toad, I can see all the schemas in database db9i.

I can see schema user1 upto user20 in toad,

Does Oracle Sql Developer have this option of showing schemas against database?

I have tried in vain.
Question by:gram77
    LVL 9

    Expert Comment

    all data which toad, sql navigator, pl/sql developer, ... shows are taken from system catalogs of oracle as all_users, all_tables, all_indexes, ...
    while connected as some user you can see only that metadata (data taken from system catalogs) to which you have acces.
    user a is owner of table x
    user b is granted select privilege on table x from user a
    user c is not granted any privilege on table x of user a

    if you connect as b, you can see table x, but if you connect as c you cannot.

    so, as for list of users, you can do "select username from all_users"
    in Oracle SQL Developer, click on name of database connection which are you connected and then on "Other Users"

    Author Comment

    When I right click on database DB2

    I get the following options in the sub menu:
    Rename Connection
    Sql*Plus worksheet
    Remote Debug
    Gather System Statistics
    Associate Migratory Repository
    Delete Migratory Repository
    Truncate Migratory Repository

    I do not have any option by "other users"
    LVL 73

    Expert Comment

    You may have Toad set up to use "DBA" views instead of "ALL" views,

    Assuming you have access to the dba views, you can then see information about other schemas, even those you don't have direct access to.

    SQL Developer only uses the "ALL" views
    LVL 9

    Accepted Solution

    you've described options you have when you click rignt mouse pad on connection ...
    firstly connect an than tree below your connection is
    other users - is the last

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now