Obtain connection to Oracle database via proxy user/schema

Help Studio
, ,
1

Hi Everyone, Im strugling to connect to my Oracle Database via proxy user. Im using standard connection string I found in documentation “USER ID=user;PROXY PASSWORD=password;DATA SOURCE=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1551)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME =base )))”. This allows my robot to connect to databse howevet I dont see tables which I should use, thats why I need to login to dedicated schema lets named it “XXX”. When Im using normal desktop SQL client I can reach my point by providing credentials user = muUserName[XXX]; pass = password. When Im trying to copy this into my connection string Im getting “Generated: ORA-01017: invalid username/password; logon denied”. I tried also some other methods like puting some additional parameters to my connection string like )));Proxy User Id=XXX;Proxy Password=password; but this doesnt help. Please can anyone help my, maybe someone struggle before with the same problem?

2

Hello guys funny that I strugle half a day with this issue but when I wrote post solution was found. I connected database using standard connection but when I want to reach schema in query i have to use its name for eg. SELECT * FROM schmema.table.

Have a greate day, hope this will help someone