asked on

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

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.

konektor

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.
imagine
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"

gram77

ASKER

konektor:
When I right click on database DB2
Schema:
|
|-->DB1
|
|-->DB2

I get the following options in the sub menu:
Connect
Disconnect
Delete
Sql*Plus
Properties
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"

Sean Stuber

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

ASKER CERTIFIED SOLUTION

konektor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial