Question about SQL Developer (Oracle freeware desktop product)
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...