SQL*Plus (MOSC)

MOSC Banner

Question about SQL Developer (Oracle freeware desktop product)

edited Mar 27, 2012 7:30PM in SQL*Plus (MOSC) 7 commentsAnswered
   Hello,

This may not be a proper community to discuss "SQL Developer". Well, could you please point out where I should to ask the following question of "SQL Developer":

I created a user "myoper" and did the following:

SQL> grant create session to myoper;

SQL> alter user scott grant connect through myoper;

SQL> connect myoper[scott]/mypassword 

SQL> desc dept

Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEPTNO                                    NOT NULL NUMBER(2)
 DNAME                                              VARCHAR2(14)
 LOC                                                VARCHAR2(13)

However, if I do the same connection "myoper[scott]" via SQL Developer, I connected, but I can see NOTHING on the left-side bar. I mean, though my current session_user is SCOTT, this SCOTT, at the moment, can not see his own objects...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center