SQL Developer


Viewing objects on lefthand side of SQL Developer.


We are having troubles with viewing objects on the lefthand side of SQL Developer. I think it has to do with permission problems. I have a proxy account but I also have a read-only account. Now I can query the tables in the worksheet but I can't see the objects on the left side like I can with my proxy account.
Is there a default value that I need to turn on or off?
Please help
Thank you 
user10697086 wrote:
We are having troubles with viewing objects on the lefthand side of SQL Developer. I think it has to do with permission problems. I have a proxy account but I also have a read-only account. Now I can query the tables in the worksheet but I can't see the objects on the left side like I can with my proxy account.
Is there a default value that I need to turn on or off?
Please help
Thank youDid you try looking for the objects you want under Other Users in the object pane when loggged in as the read-only acocunt? 
When logging into my read only account, my username doesn't show up under other users. 
Other Users is only for OTHER users.
If you're the owner of the objects, they should be displayed in the main tree as you expect.
Does your user have correct privileges to use ALL_ views?
Specifically, on 10g this query is used to populate the Tables tree:
select * from (
  SELECT o.OBJECT_NAME, o.OBJECT_ID ,'' short_name, decode(bitand(t.property, 32), 32, 'YES', 'NO') partitioned,
                decode(bitand(t.property, 64), 64, 'IOT',
               decode(bitand(t.property, 512), 512, 'IOT_OVERFLOW',
               decode(bitand(t.flags, 536870912), 536870912, 'IOT_MAPPING', null))) iot_type,
         o.OWNER OBJECT_OWNER, o.CREATED, o.LAST_DDL_TIME, O.GENERATED, O.TEMPORARY, case when xt.obj# is null then 'N' else 'Y' end EXTERNAL
    FROM SYS.ALL_OBJECTS O ,sys.tab$ t, sys.external_tab$ xt
    WHERE O.OWNER = :SCHEMA
    and   o.object_id = t.obj#(+)
    and   o.object_id = xt.obj#(+)
    AND O.OBJECT_TYPE = 'TABLE'
union all
SELECT OBJECT_NAME, OBJECT_ID , syn.SYNONYM_NAME short_NAME, decode(bitand(t.property, 32), 32, 'YES', 'NO') partitioned,
                decode(bitand(t.property, 64), 64, 'IOT',
               decode(bitand(t.property, 512), 512, 'IOT_OVERFLOW',
               decode(bitand(t.flags, 536870912), 536870912, 'IOT_MAPPING', null))) iot_type,
       SYN.TABLE_OWNER OBJECT_OWNER, o.CREATED, o.LAST_DDL_TIME, O.GENERATED, O.TEMPORARY, case when xt.obj# is null then 'N' else 'Y' end EXTERNAL
              FROM SYS.ALL_OBJECTS O, sys.user_synonyms syn,sys.tab$ t, sys.external_tab$ xt
              WHERE  syn.table_owner = o.owner
              and    syn.TABLE_NAME = o.object_NAME
              and    o.object_id = t.obj#
                and   o.object_id = xt.obj#(+)
              and    o.object_type = 'TABLE'
              and    :INCLUDE_SYNS = 1
              and    :SCHEMA = USER
)Can you run that in a worksheet?
Hope that helps,
K. 
I recieved the following error
Bind Variable "SCHEMA" is NOT DECLARED
Do I need to substitute a variable with my user name? I'm unsure about access to ALL_VIEWS. I'm still checking into it.
Thanks 
Run as statement (F9) instead as script (F5) to be prompted for the binds.
K. 
I received the following message
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:   
*Action:
Error at Line: 7 Column: 44 
Then that's the answer to your question: you lack select privileges on sys.external_tab$ (exceptionally the table might not exist).
Regards,
K.

Related Links

EA2 - invalid option for ALTER SESSION when logging in to 9i DB via EA2
Issue regarding display
Sql developer 2.1 error messages
SQL Developer and instantClient in iMac
Source does not have a runnable target
SQL Developer 2.1 EA2 does not show any procedures
SQL Developer 2.1 EA2 and Version Control issue
git support?
SQL Developer 2.1 EA2 issue with TNS connections
Where is the MySQL JDBC driver file?
Issue with viewing packages in SQL Developer EA2
Bug tracking in Sql Developer (stable and EA ver.)
SQL Dev with DB2 and Sybase
2.1 EA2: Attempting to Run Test or Suite displays error dialog
2.1 EA1/EA2: Disappearing text
Can not paste multiple columns

Categories

ORACLE DEV
Fusion Middleware
General Database Discu...
XML
Database Connectivity
Performance & Availabi...
LCM: 11i Install/Upgrade
OO4O and Wizards [ARCH...
Downloads Issues
Workspace Manager
Oracle Help Technologies
Discrete Manufacturing
Advanced Planning & Sc...
Industries Archived Fo...
Integration and Events
Financial Services
Database Archived Forums
PHP
SOA & Process Manageme...
Data Guard
On Demand: SaaS and Ma...
ILM Assistant
MapViewer
Content Database
Database (Korean)
Technologies (Korean)
Linux (Korean)
Communications Service...
Hyperion Developer Net...
Siebel Mobile
Coherence
SOA Suite and OC4J 11g...
Smart Space
Test Management/Functi...
WebCenter - Interaction
Business Process Manag...
WebLogic Server - Clus...
Service Architecture L...
iStore
weblogic.developer.int...
weblogic.developer.int...
weblogic.support.install
weblogic.developer.int...
Tuxedo Newsgroups
Pages
WebLogic Server - Web ...
应用软件
Industries
Construction and Engin...
广州 User Group
Oracle WebLogic Commun...
User Productivity Kit ...
PeopleSoft OVM Templates
Private Discussion For...
Java HotSpot Virtual M...
Collections: Lists, Se...
Naming and Directory (...
Java ME SDK
Developing Application...
Solaris on x86
DTrace
JVMTI [ARCHIVE]
AVK Portability
OpenSSO
開発ツール製品
General Java Developme...
Oracle WebLogic Server...
NoSQL Database
Platform as a Service ...
Oracle JRockit (Japanese)
Fusion Applications
システム管理
Windows .NET (Korean)
Java Mission Control
Oracle Mobile
WebCenter Portal JSK
About the Community
Oracle Messaging Cloud...
Portuguese
Social Media Hub
Utah Eloqua Users
Austin Eloqua Users
Eastern Canada Eloqua ...
Markies: Best Internat...
Markies: Extraordinary...
Oracle Compute Cloud S...
Pune People
API Management
BICS Data Visualization
Oracle Process Cloud S...
Java Community Process
Oracle Tape Storage
Middleware Partner Com...
Oracle Linux Networking
OU Guided Boot Camps
Data Visualization Des...
Global Human Resources
Uruguay
NightHacking
Pittsburgh Area Users
Containers
Big Data Cloud Infrast...
Duke's Choice Award 2016
See It
Tajikistan Oracle User...
Eloqua Basic Learner
Spatial
Business Intelligence ...
Identity Manager
LCM: Managing Oracle A...
Data Mining
C++ Call Interface (OCCI)
BPEL
Upgrades and Migration
OA Framework (Korean)
Automated Regression T...
weblogic.developer.int...
产品专区
Java Programming
Java System Portal Ser...
PLM Community
Test Partner Industry ...

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App