23 responses

  1. David Grimberg
    March 12, 2013

    Is there a configuration setting to make this the default for new connections? How about retro actively applying it to dozens of current connections, on both the tables and views nodes?

    • thatjeffsmith
      thatjeffsmith
      March 12, 2013

      No way to make it default for connections. Not for multiple existing connections either. Sounds like an idea for the Exchange though – default filters for connections?

  2. Mike McCaffrey
    May 24, 2013

    Very helpful; thanks.

    • thatjeffsmith
      thatjeffsmith
      May 24, 2013

      No worries Mike!

  3. Nathan
    March 4, 2014

    Smith,

    It’s pretty good, was very helpful to me. Keep on post.

    Cheers !!!

    • thatjeffsmith
      thatjeffsmith
      March 4, 2014

      Thanks Nathan!

  4. agnieszka
    March 6, 2014

    Yes but I stii can’t see objects granted by another user.
    As you have written “It’s a pretty common security scheme to create a user with very low privilege levels and then only grant SELECT on objects they should see”. The owner of objects granted only select on them for another simple user but did’nt create synonyms. Is there any way in sql developer for such simple user to see such objets ?

    • thatjeffsmith
      thatjeffsmith
      March 6, 2014

      Probably not. If there’s no visibility in your ALL_OBJECTS types data dictionary views, then we can’t see. That doesn’t stop you from querying them, but you have to know about them.

      It could be argued that this was done intentionally – you might want to confirm this with your DBA. If it’s an oversight, asking for a synonym wouldn’t be asking for too much. Be prepared to say WHY you need it though.

  5. Attil
    March 6, 2014

    And what should I do, when there is not Tables in my connection?
    I created my tables, but the Tables above the views is gone.
    https://ws.cubby.com/p/_dd74496df8a14d958389818696987f41/asdfasddf.jpg/840631261

    • thatjeffsmith
      thatjeffsmith
      March 6, 2014

      You can try a restart – sometimes that fixes it. But it might be better to upgrade to version 4.0.1 – I’ve not see this happen in that version.

      • Attil
        March 6, 2014

        Ok, thank you.

  6. rohan
    March 12, 2014

    Hi Jeff,

    I really like your site and I have learnt a lot of things . I had question for you. Recently I have started studying a database of another project.The DBA has given me only “Read_Only” acess. Now I am not able to see any tables listed under the schema. I did query user_objects and I did not find any record under the table. So is that the reason? If yes what should I communicate to the DBA to get the thing done (I.e display the tables under the schema )

    • thatjeffsmith
      thatjeffsmith
      March 12, 2014

      The tables belong to someone else. The ‘other users’ node in your connection tree will help you find them. Or look under your views/synonyms.

      • rohan
        March 13, 2014

        You are awesome!!. The ‘Other User’ node works for me perfectly.

      • thatjeffsmith
        thatjeffsmith
        March 13, 2014

        Great news :) Enjoy the ride!

      • Rohan
        April 2, 2014

        Jeff, I am able to see table, views, Indexes but in ‘other users’ node I am not able to see packages, functions,synonms etc. What could be the reason and what is possible soultions?

      • thatjeffsmith
        thatjeffsmith
        April 3, 2014

        You can’t see the names or you can’t see the source? Or both?

  7. rohan
    April 3, 2014

    Just the way I click on tables , and it expands and shows all the tables under schema, similarly when I click on packages it does not list all the packages under the schema. Same applies for functions and synonms. But when I login with another user who has read and write access , it lists all packages under the schema.

    • thatjeffsmith
      thatjeffsmith
      April 5, 2014

      You see some packages, but not all packages? Or you see no packages?

      Either way, I’d run SQL Developer in debug mode to see what is happening. You’ll see the queries run, and the tree nodes populated in the log panel…

  8. Thayumanavan Ramasamy
    June 5, 2014

    Brilliant Smith. It works for me. Many thanks for this. Until I see your post I use to go to Other Users where I have to select 1 out of 80 odd users… Thanks again…Cheers Thayu

  9. Arpit
    June 18, 2014

    Thanks , Solved my problem.

  10. rahul
    July 24, 2014

    I created table named P_dump on toad, but when i tried to access the same table using oracle sql developer, it is not there. I have also included synonyms, but still it is not visible there. Please suggest a solution.

    • thatjeffsmith
      thatjeffsmith
      July 24, 2014

      So run something like

      select table_name from user_tables;
      

      If you don’t see ‘P_DUMP’ – then you didn’t create the table where you thought you did.

      Try using the View > Find DB Object and interrogate all of the database schemas for your table. It’s in there, somewhere.

Leave a Reply

 

 

 

Back to top
mobile desktop