5 Replies Latest reply on Sep 11, 2012 8:13 PM by Gary Graham-Oracle

    Viewing Tables/Schema

      What rights does a user need in order to be able to expand the "Tables" node in the left hand column and actually see tables?
      Currently, my user can connect, but the "tables" node will not expand and display the tables.
        • 1. Re: Viewing Tables/Schema
          Gary Graham-Oracle
          Hi Ken,

          You don't give details about the environment/versions, but here are a couple of recurring scenarios on this forum:
          1. Bug 12382135 - NO TABLES SHOWN IN NAV

          Both are discussed in the following thread:
          Re: 30EA4 - Unable to expand tables node

          As noted there, (1) was fixed long ago. (2) was only fixed recently and will be in the next release. Perhaps one of these applies to your user's situation?

          SQL Developer Team
          • 2. Re: Viewing Tables/Schema
            I left the version of SqlDeveloper out as this situation seems to occur with the three most recent version - I have tried them all.
            Target DB's: Oracle 11g R2
            User Grants: connect, resource, create_sesson, select_any_dictionary

            SqlDeveloper version currently being used.

            Oracle SQL Developer 3.0.04
            Version 3.0.04
            Build MAIN-04.34
            Copyright © 2005, 2011 Oracle. All Rights Reserved.
            IDE Version:
            Product ID: oracle.sqldeveloper
            Product Version:


            Component     Version
            =========     =======
            Java(TM) Platform     1.6.0_11
            Oracle IDE
            Versioning Support


            Name     Value
            ====     =====
            awt.toolkit     sun.awt.windows.WToolkit
            class.load.environment     oracle.ide.boot.IdeClassLoadEnvironment
            class.load.log.level     CONFIG
            class.transfer     delegate
            file.encoding     Cp1252
            file.encoding.pkg     sun.io
            file.separator     \
            http.agent     Mozilla/5.0 (Java 1.6.0_11; Windows Vista 6.1 x86; en_US) ICEbrowser/v6_1_3
            http.nonProxyHosts     qtso.com|cmf.gov||remote.stemc.org|portal.sjhsyr.org|ctxweb2|ftp.mvnhealth.com|192.168.*.*|172.21.*.*|172.19.*.*|172.17.*.*|172.16.*.*|localhost|localhost.localdomain||::1|SID8426.mvn.local|SID8426
            http.proxyHost     proxy.mvn.local
            http.proxyPort     43329
            https.nonProxyHosts     qtso.com|cmf.gov||remote.stemc.org|portal.sjhsyr.org|ctxweb2|ftp.mvnhealth.com|192.168.*.*|172.21.*.*|172.19.*.*|172.17.*.*|172.16.*.*|localhost|localhost.localdomain||::1|SID8426.mvn.local|SID8426
            https.proxyHost     proxy.mvn.local
            https.proxyPort     43329
            ice.browser.forcegc     false
            ice.pilots.html4.ignoreNonGenericFonts     true
            ice.pilots.html4.tileOptThreshold     0
            ide.AssertTracingDisabled     true
            ide.bootstrap.start     517798123525292
            ide.build     MAIN-04.34
            ide.conf     D:\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
            ide.config_pathname     D:\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
            ide.debugbuild     false
            ide.devbuild     false
            ide.extension.search.path     sqldeveloper/extensions:jdev/extensions:ide/extensions
            ide.firstrun     true
            ide.java.minversion     1.6.0_04
            ide.launcherProcessId     8432
            ide.main.class     oracle.ide.boot.IdeLauncher
            ide.patches.dir     ide/lib/patches
            ide.pref.dir     C:\Users\kdefilip\AppData\Roaming\SQL Developer
            ide.pref.dir.base     C:\Users\kdefilip\AppData\Roaming
            ide.product     oracle.sqldeveloper
            ide.shell.enableFileTypeAssociation     D:\sqldeveloper\sqldeveloper.exe
            ide.splash.screen     splash.gif
            ide.startingArg0     D:\sqldeveloper\sqldeveloper.exe
            ide.startingcwd     D:\sqldeveloper
            ide.user.dir     C:\Users\kdefilip\AppData\Roaming\SQL Developer
            ide.user.dir.var     IDE_USER_DIR
            ide.vcs.noapplications     true
            ide.work.dir     \\prof1-nt\home\kdefilip\Personal\SQL Developer
            ide.work.dir.base     \\prof1-nt\home\kdefilip\Personal
            ilog.propagatesPropertyEditors     false
            java.awt.graphicsenv     sun.awt.Win32GraphicsEnvironment
            java.awt.printerjob     sun.awt.windows.WPrinterJob
            java.class.path     ..\..\ide\lib\ide-boot.jar
            java.class.version     50.0
            java.endorsed.dirs     D:\sqldeveloper\jdk\jre\lib\endorsed
            java.ext.dirs     D:\sqldeveloper\jdk\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
            java.home     D:\sqldeveloper\jdk\jre
            java.io.tmpdir     C:\Users\kdefilip\AppData\Local\Temp\
            java.library.path     D:\sqldeveloper;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:\ORACLE\INSTANTCLIENT_11_2;D:\PROGRA~1\CENTRI~1.5\ORACLE\BIN;C:\Windows\SYSTEM32;C:\Windows;D:\ORACLE\INSTANTCLIENT_11_2;C:\Windows\SYSTEM32\WBEM;C:\Windows\SYSTEM32\WINDOWSPOWERSHELL\V1.0\;C:\PROGRAM FILES\NOVELL\GROUPWISE;D:\PROGRA~1\CENTRI~1.5;C:\Windows\SYSTEM32\WINDOWS SYSTEM RESOURCE MANAGER\BIN;C:\Windows\IDMU\COMMON;D:\Program Files\WIDCOMM\Bluetooth Software\;C:\Program Files\EaseUS\Todo Backup\bin\
            java.naming.factory.initial     oracle.javatools.jndi.LocalInitialContextFactory
            java.protocol.handler.pkgs     oracle.jdevimpl.handler
            java.runtime.name     Java(TM) SE Runtime Environment
            java.runtime.version     1.6.0_11-b03
            java.specification.name     Java Platform API Specification
            java.specification.vendor     Sun Microsystems Inc.
            java.specification.version     1.6
            java.util.logging.config.file     logging.conf
            java.vendor     Sun Microsystems Inc.
            java.vendor.url     http://java.sun.com/
            java.vendor.url.bug     http://java.sun.com/cgi-bin/bugreport.cgi
            java.version     1.6.0_11
            java.vm.info     mixed mode
            java.vm.name     Java HotSpot(TM) Client VM
            java.vm.specification.name     Java Virtual Machine Specification
            java.vm.specification.vendor     Sun Microsystems Inc.
            java.vm.specification.version     1.0
            java.vm.vendor     Sun Microsystems Inc.
            java.vm.version     11.0-b16
            jdbc.library     /D:/sqldeveloper/jdbc/lib/ojdbc6.jar
            line.separator     \r\n
            log.file.name     D:\sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\log\datamodeler.log
            oracle.home     D:\sqldeveloper
            oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG     true
            oracle.jdbc.mapDateToTimestamp     false
            oracle.translated.locales     de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW
            oracle.xdkjava.compatibility.version     9.0.4
            orai18n.library     /D:/sqldeveloper/jlib/orai18n.jar
            os.arch     x86
            os.name     Windows Vista
            os.version     6.1
            path.separator     ;
            reserved_filenames     con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$
            sqldev.debug     false
            sun.arch.data.model     32
            sun.boot.class.path     D:\sqldeveloper\jdk\jre\lib\resources.jar;D:\sqldeveloper\jdk\jre\lib\rt.jar;D:\sqldeveloper\jdk\jre\lib\sunrsasign.jar;D:\sqldeveloper\jdk\jre\lib\jsse.jar;D:\sqldeveloper\jdk\jre\lib\jce.jar;D:\sqldeveloper\jdk\jre\lib\charsets.jar;D:\sqldeveloper\jdk\jre\classes
            sun.boot.library.path     D:\sqldeveloper\jdk\jre\bin
            sun.cpu.endian     little
            sun.cpu.isalist     pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
            sun.desktop     windows
            sun.io.unicode.encoding     UnicodeLittle
            sun.java2d.ddoffscreen     false
            sun.jnu.encoding     Cp1252
            sun.management.compiler     HotSpot Client Compiler
            sun.os.patch.level     Service Pack 1
            svnkit.sax.useDefault     true
            user.country     US
            user.dir     D:\sqldeveloper\sqldeveloper\bin
            user.home     C:\Users\kdefilip
            user.language     en
            user.name     kdefilip
            user.timezone     America/New_York


            Name     Identifier     Version     Status
            ====     ==========     =======     ======
            Check For Updates     oracle.ide.webupdate     Loaded
            Code Editor     oracle.ide.ceditor     Loaded
            Component Palette     oracle.ide.palette1     Loaded
            Data Miner     oracle.dmt.dataminer     Loaded
            Database Connection Support     oracle.jdeveloper.db.connection     Loaded
            Database Object Explorers     oracle.ide.db.explorer     Loaded
            Database UI     oracle.ide.db     Loaded
            Diagram Framework     oracle.diagram     Loaded
            Diagram Javadoc Extension     oracle.diagram.javadoc     Loaded
            Diagram Thumbnail     oracle.diagram.thumbnail     Loaded
            Diff/Merge     oracle.ide.diffmerge     Loaded
            Extended IDE Platform     oracle.javacore     Loaded
            External Tools     oracle.ide.externaltools     Loaded
            File Support     oracle.ide.files     Loaded
            Help System     oracle.ide.help     Loaded
            History Support     oracle.jdeveloper.history     Loaded
            Import/Export Support     oracle.ide.importexport     Loaded
            Index Migrator support     oracle.ideimpl.indexing-migrator     Loaded
            JDeveloper Runner     oracle.jdeveloper.runner     Loaded
            JViews Registration Addin     oracle.diagram.registration     Loaded
            Log Window     oracle.ide.log     Loaded
            Mac OS X Adapter     oracle.ideimpl.apple     Loaded
            Navigator     oracle.ide.navigator     Loaded
            Object Gallery     oracle.ide.gallery     Loaded
            Oracle IDE     oracle.ide     Loaded
            Oracle SQL Developer     oracle.sqldeveloper     Loaded
            Oracle SQL Developer - 3rd Party Database Browsers     oracle.sqldeveloper.thirdparty.browsers     Loaded
            Oracle SQL Developer - DBA Navigator     oracle.sqldeveloper.dbanavigator     Loaded
            Oracle SQL Developer - Extras     oracle.sqldeveloper.extras     Loaded
            Oracle SQL Developer - File Navigator     oracle.sqldeveloper.filenavigator     Loaded
            Oracle SQL Developer - Migrations Antlr3 Translator     oracle.sqldeveloper.migration.translation.core_antlr3     Loaded
            Oracle SQL Developer - Migrations Application Migration     oracle.sqldeveloper.migration.application     Loaded
            Oracle SQL Developer - Migrations Core     oracle.sqldeveloper.migration     Loaded
            Oracle SQL Developer - Migrations DB2     oracle.sqldeveloper.migration.db2     Loaded
            Oracle SQL Developer - Migrations DB2 Translator     oracle.sqldeveloper.migration.translation.db2     Loaded
            Oracle SQL Developer - Migrations Microsoft Access     oracle.sqldeveloper.migration.msaccess     Loaded
            Oracle SQL Developer - Migrations Microsoft SQL Server     oracle.sqldeveloper.migration.sqlserver     Loaded
            Oracle SQL Developer - Migrations MySQL     oracle.sqldeveloper.migration.mysql     Loaded
            Oracle SQL Developer - Migrations Sybase Adaptive Server     oracle.sqldeveloper.migration.sybase     Loaded
            Oracle SQL Developer - Migrations T-SQL Translator     oracle.sqldeveloper.migration.translation.core     Loaded
            Oracle SQL Developer - Migrations Teradata     oracle.sqldeveloper.migration.teradata     Loaded
            Oracle SQL Developer - Migrations Translation UI     oracle.sqldeveloper.migration.translation.gui     Loaded
            Oracle SQL Developer - Object Viewer     oracle.sqldeveloper.oviewer     Loaded
            Oracle SQL Developer - Real Time SQL Monitoring     oracle.sqldeveloper.sqlmonitor     Loaded
            Oracle SQL Developer - Reports     oracle.sqldeveloper.report     Loaded
            Oracle SQL Developer - Scheduler     oracle.sqldeveloper.scheduler     Loaded
            Oracle SQL Developer - Schema Browser     oracle.sqldeveloper.schemabrowser     Loaded
            Oracle SQL Developer - SearchBar     oracle.sqldeveloper.searchbar     Loaded
            Oracle SQL Developer - Snippet     oracle.sqldeveloper.snippet     Loaded
            Oracle SQL Developer - Spatial     oracle.sqldeveloper.spatial     Loaded
            Oracle SQL Developer - TimesTen     oracle.sqldeveloper.timesten     Loaded
            Oracle SQL Developer - Tuning     oracle.sqldeveloper.tuning     Loaded
            Oracle SQL Developer - Unit Test     oracle.sqldeveloper.unit_test     Loaded
            Oracle SQL Developer - User Extensions Support     oracle.sqldeveloper.userextensions     Loaded
            Oracle SQL Developer - Worksheet v2     oracle.sqldeveloper.worksheet     Loaded
            Oracle SQL Developer - XML Schema     oracle.sqldeveloper.xmlschema     Loaded
            Oracle SQL Developer Data Modeler     oracle.datamodeler     Loaded
            Oracle SQL Developer Data Modeler - Reports     oracle.sqldeveloper.datamodeler_reports     Loaded
            PROBE Debugger     oracle.jdeveloper.db.debug.probe     Loaded
            Peek     oracle.ide.peek     Loaded
            Persistent Storage     oracle.ide.persistence     Loaded
            Property Inspector     oracle.ide.inspector     Loaded
            QuickDiff     oracle.ide.quickdiff     Loaded
            Replace With     oracle.ide.replace     Loaded
            Runner     oracle.ide.runner     Loaded
            VHV     oracle.ide.vhv     Loaded
            Versioning Support     oracle.jdeveloper.vcs     Loaded
            Versioning Support for Subversion     oracle.jdeveloper.subversion     Loaded
            Virtual File System     oracle.ide.vfs     Loaded
            Web Browser and Proxy     oracle.ide.webbrowser     Loaded
            XML Editing Framework IDE Extension     oracle.ide.xmlef     Loaded
            audit     oracle.ide.audit     Loaded
            classpath: protocol handler extension     oracle.jdeveloper.classpath     Loaded
            jdukshare     oracle.bm.jdukshare     Loaded
            mof-xmi     oracle.mof.xmi     Loaded
            oracle.ide.dependency     oracle.ide.dependency     Loaded
            oracle.ide.indexing     oracle.ide.indexing     Loaded
            palette2     oracle.ide.palette2     Loaded
            status     oracle.ide.status     Loaded
            • 3. Re: Viewing Tables/Schema
              Gary Graham-Oracle

              So if neither of those bugs apply to your user's scenario (and Bug 13953985 occurs with either of SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY privilege), and you are certain it is not some unusual security issue, then the only other advice I can give would be here:
              Re: [SQL Developer 3.0.04] Cannot Drill Down

              • 4. Re: Viewing Tables/Schema
                Yes. It seems that if the user selects the schema browser he can then see the tables. However, nothing is visible in the left column.
                • 5. Re: Viewing Tables/Schema
                  Gary Graham-Oracle
                  We may be talking past each other a bit here. I don't really get what you mean. Is it something like:

                  1. On
                  2. Connect to a user having select any dictionary privilege
                  3. Open Schema Browser
                  4. My user can see ... what?

                  Tables in the drop-down list for that user? Another user? What do you mean by left column? The column tab in the object viewer pane? The data tab in the object viewer pane? Give as precise a description as possible.