Search code examples
oracleoracle-sqldeveloperdbobject

How to view other users' objects like mine in Oracle SQL Developer?

When I access other users' objects, I can do something like

select * from user_2.booking_table;

given that I have the privileges over user_2's objects.

Using the console, I know I can do

alter session set current_schema=user_2;

to avoid prefixing user_2 in front of object's name - so I can do

select * from booking_table;

as if booking_table is my table without specifying user_2 each time.

If I want to bring similar idea to GUI client...

Using Oracle SQL Developer, under each connection, I know I can browse other users' objects under the tree node Other Users > user_2 > Tables/Views/Indexes etc...

Is there anyway I can "import" user_2's objects so that they appear under my Tables, Views, Indexes, etc under the connection, as if they look like they are my objects?

Solution

  • No. We show you what you have, or what other schemas have.

    The only way to get close to what you're looking for is if you were to create synonyms to tables in other schemas, then you can ask SQL Developer to present those as TABLES in your connection list.

    I'm logged in as a user with an 'empty' schema, at least as far as tables are concenred.

    enter image description here

    I enable this filter check item, and click 'OK' -

    enter image description here

    I talk about this in detail here.

    Disclaimer: I'm the product manager for Oracle SQL Developer.