Sql Optimizer version 8.6 supports proxy authentication. But when I try to run a query this way, I am getting a password is null error. Proxy works correctly in TOAD (10.6) but I can’t figure out if I need to do something special in Sql Optimizer in order to get it to work correctly. Does anyone have any experience with this issue?
SQL Optimizer does support proxy authentication. However, I do see a problem when using the “Auto Optimize SQL” feature within Toad.
Can you confirm if this is also how you encountered this problem. If not, please send the steps that you used to repeat the problem.
Regarding the problem in “Auto Optimize SQL” when using proxy authentication, I am now investigating and will get back to you later.