Proxy user login does not show tables objects etc
phw198Jun 12 2008 — edited Dec 22 2008Database instance: 10.2.0.1
SQL Developer: 1.5.1 (build 5440)
Consider the following setup:-
create user proxy_user identified by proxy_password;
grant connect to proxy_user;
alter user main_user grant connect through proxy_user;
Now. in SQLplus I can enter...
Username: proxy_user[main_user]
Password: proxy_password
...and I will be connected as the main_user and have access to all their objects. However, if I set up the same connection in Oracle SQL developer, once connected it displays no objects in the tree-view under Table, View etc... In addition, because it is proxy connected, it also doesn't show main_user's object under "Other Users" either!
I have played with using the "Proxy Connection" check box on the connection dialogue box, but either this demands the password for main_user or a distinguished name.
Is this a bug, or am I doing something wrong? TIA,
Paul