1

I am using SQL Developer and now I can SELECT but viewing those tables in the list is not available. Is there some configuration I need to do in order to see the tables? User has select all tables privileges.

I am expanding the tree under my own user, not under the user who owns the tables.

Paul White ♦
95.4k30 gold badges440 silver badges689 bronze badges
asked Oct 3, 2016 at 6:21
0

1 Answer 1

6

For where you are looking, you can only see the tables that exist in the schema that belongs to the user you supplied in your connection details.

If you want to see 'the tables' - you need to expand the 'Other Users' node, and explore the users there, and go to their respective tables list.

If you can query these objects in a worksheet w/o adding a SCHEMA. prefix to the FROM clause, it's because there is a SYNONYM that allows you to do so.

You can configure SQLDev to show these SYNONYMS as tables in your tree.

enter image description here

I talk about how to do this here.

answered Oct 3, 2016 at 19:57

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.