Autocomplete dropdown lists dosen't work on a proxed user

[DM456]

Hi,

I use pl\sql dev. to connect to a Oracle DB 11.2.0.3 using an oracle proxy user :

p.e. : ALTER USER BOB GRANT CONNECT THROUGH TED;

If I login using BOB all works fine.

when I try to connect using TED user to access the BOB schema the "Autocomplete dropdown lists" dosen't wirk at all.

is there some option the enable the drop list using a proxy user?

it works in version 7, but not on version 9 and 10.

thank you!!

 

[Marco Kalter]

Can you let me know and example of an autocomplete list that does not work?

 

[DM456]

Hi,

I try :

"select * from "
"select * from BOB. "
"select * from BOB.TABLE1 T where T. "

in any case the drill down autocomplete tab don't appear, in version 7 it still work great.

I guess that the autocomplete try to look for TED (the proxy user ) object and not for BOB ojbect ( real owner ).

please note that SQLPLUS proced connect "show user" command return correctly "BOB" and not TED.

 

[DM456]

Hi Marco,

do you have any news for me? do you do any test on this issue?

for us is quite a big problem, our devleopers are evaluating to change dev tool, could you kindly let me know if you find a workaround?

DM

 

[Marco Kalter]

No news yet. We're looking into this.

 

[DM456]

Hi Marco,

thank you for your support, let me know if your developer found a workaround for this issue,

good work!

DM

 

[DM456]

Hi Marco,

is approaching the time to decide which tool to continue to use the company, do your developer find a patch or a workaround for autocomplete issue?

good work!

DM

 

[Marco Kalter]

We do not yet have a fix. I can't give you an exact date yet.

 

[Arky]

Marco,
I have a similar issue with the autocomplete issue.

Scenario:
a)Log in as user USER1
b)alter session set current_schema = USER2;

There is no way to use autocomplete apart from using USER2.TABLE1. syntax. Is there any workaround on this or this is part of the same issue that DM456 mentions above?

Thanks

 

[Marco Kalter]

If you mean the Code Assistant, then this partially works. This does not work:

1. connect as sys

2. alter session set current_schema=scott

3. select * from dep|

The Code Assistant will not list tables starting with dep, because PL/SQL Developer made a snapshot of available tables when the connection as sys was made, and this is not updated after setting the current_schema (which would be too time consuming).

This however does work:

3. select * from dept d where d.|

Now the Code Assistant will resolve the d alias for the current_schema, and columns for scott.dept will be listed.

 

[Arky]

Thanks Marco for the rapid answer.

Yes, my actual problem is the first situation you describe. I don't know if there would be a meaning if you could add a "refresh current user objects" or something functionality. It would surely help me

Aris