Making read-only schema visible in SqlDeveloper

Every now and then I need some tool to perform queries on a Oracle Database. If I need it really occasionally on a project I just use the SQL view in Netbeans. In case I need a more mature tool I normally download the freely available SqlDeveloper from Oracle. In my last project I got a Oracle user with read only rights on the database. This way I could have a peek in the database without the risk of changing (and breaking) things. However after I logged in with this account I didn’t see any table:

Luckily quite soon I was told it is standard behaviour in SqlDeveloper. The workaround is to go select the user in the browser and within that node you can see all tables available:

About Pascal Alma

Pascal is a senior IT consultant and has been working in IT since 1997. He is monitoring the latest development in new technologies (Mobile, Cloud, Big Data) closely and particularly interested in Java open source tool stacks, cloud related technologies like AWS and mobile development like building iOS apps with Swift. Specialties: Java/JEE/Spring Amazon AWS API/REST Big Data Continuous Delivery Swift/iOS
This entry was posted in Technical and tagged . Bookmark the permalink.