for a new Database Application i have to try out the oracle feature proxy user.The Option Proxy User gives you the possibility to login with your account as another user.
connect test1/test1 (-> Connected as user test1)
if you want that user test1 can be logged in as for example test2 , you have to set this grant:
alter user test2 grant connect through test1;
… and then you can login like this
connect test1[test2]/test1 (-> Connected as user test2)
And now i have the problem, it isn
t possible to enter test1[test2] in the field username by the database connection window. This field doesnt accept [ ], the only way is to put into this field with copy and paste but then i get an error message.
I tried this also with the Tool Toad and see there it works.
QUESTION: Is there the possibility in sql navigator to connect a database with the proxy user feature?
I hope you can help me!