Connection to Oracle Database with proxy user does not work

Toad Data Modeler
1

Hi,

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?

2

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

2019-08-05%2015_51_17-Connections
2019-08-05 15_51_17-Connections.png686×551 41.6 KB

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

Best regards,
Michal

3

Wonder how to connect as a proxy account through Toad for Oracle.
I am getting invalid user or password if I specify user as: user1[shcemaOwner] in the User: field.

Thanks
Larry