This discussion is archived
5 Replies Latest reply: Sep 11, 2012 1:13 PM by Gary Graham RSS

Viewing Tables/Schema

525623 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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
    525623 Newbie
    Currently Being Moderated
    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
    ====     =====
    class.load.environment     oracle.ide.boot.IdeClassLoadEnvironment
    class.load.log.level     CONFIG
    class.transfer     delegate
    file.encoding     Cp1252
    file.separator     \
    http.agent     Mozilla/5.0 (Java 1.6.0_11; Windows Vista 6.1 x86; en_US) ICEbrowser/v6_1_3
    http.proxyHost     proxy.mvn.local
    http.proxyPort     43329
    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     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     sqldeveloper/extensions:jdev/extensions:ide/extensions
    ide.firstrun     true     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     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     \\prof1-nt\home\kdefilip\Personal\SQL Developer     \\prof1-nt\home\kdefilip\Personal
    ilog.propagatesPropertyEditors     false
    java.awt.graphicsenv     sun.awt.Win32GraphicsEnvironment
    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     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(TM) SE Runtime Environment
    java.runtime.version     1.6.0_11-b03     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.version     1.6.0_11     mixed mode     Java HotSpot(TM) Client VM     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     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     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     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     UnicodeLittle
    sun.java2d.ddoffscreen     false
    sun.jnu.encoding     Cp1252     HotSpot Client Compiler
    sun.os.patch.level     Service Pack 1
    svnkit.sax.useDefault     true     US
    user.dir     D:\sqldeveloper\sqldeveloper\bin
    user.home     C:\Users\kdefilip
    user.language     en     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     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     Loaded
    Navigator     oracle.ide.navigator     Loaded
    Object 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     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     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 Expert
    Currently Being Moderated

    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
    525623 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points