Toad World® Forums

Connection to Oracle Database with proxy user does not work


We are using proxy accounts to login to our Oracle database.

In Oracle Developer it works like this:

login: mypersonaluser[stg]
passowrd: pw of mypersonaluser

So I am logged in as user stg and have all his rights.

When I try this in Toad Data Modeler I get the error message:
"Connection failed because of following error: "ORA-01017: invalid username/password;logon denied""

How can I log correctly with proxy user?

Hello Johannes,
If you need to connect via proxy user, please use Native Client Connection (at Select Data Provider step of New Connection wizard)

Tested on Toad Data Modeler 7.0 and Oracle 11R2 and Oracle 12R2.

Best regards,