Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Proxy users w/VS Code

ScottOct 6 2019 — edited Mar 23 2020

I tried to make a connection using a proxy user, using the following syntax:  PROXY_USER[TARGET_USER]

This works fine in SQL Developer/SQLPlus, but I get an ORA-01017: invalid username/password; login denied error in VS Code.

Running the latest build (19.3.2).

Thoughts?

- Scott -

This post has been answered by Christian.Shay -Oracle on Oct 7 2019
Jump to Answer

Comments

Christian.Shay -Oracle
Answer

Hi Scott,

We don't support that syntax yet, but in the meantime you can do the following to connect proxy users:

  • To connect to Oracle Database from a .SQL or .PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown
  • To connect from Oracle Database Explorer, click the plus sign button
  • A connection dialog will open. In the Connection Type dropdown, select ODP.NET Connect String
  • In the Connection String field, enter a string with this format if providing the hostname, port and service name explicitly: User Id=myuser;Data Source=dbhostname:1521/DBSERVICENAME;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
  • If using a TNS Alias, enter a connect string with this format: User Id=myuser;Data Source=mytnsalias;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
  • Provide a connection name to be used to reference this connection in Database Explorer and elsewhere
  • Click the Create Connection button

For more tips, see the quickstart:

https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodequickstart.html

Marked as Answer by Scott · Oct 6 2019
Scott

Perfect - that worked like a charm!

- Scott -

Hi Scott,
In our newest 19.3.3 release we made it a lot easier to connect using a proxy user. Please try it out and let me know any feedback about the release!
(In any connection dialog, check the Show more options checkbox and provide the proxy username and password)

User_6BTKC

Hello,
Am I being dense with the new dialog
In the examples here
alter user hr grant connect through scott;
connect scott[hr]/tiger
in the new dialog should I be entering scott in user name and scott[hr] in the proxy user name?

User_6BTKC

Ignore me all i was being dense. The proper syntax in the new dialog is
EX alter user hr grant connect through scott;
It is to place the target user HR in user name, and scott and scott's password in the new proxy user fields.

1 - 5

Post Details

Added on Oct 6 2019
5 comments
1,276 views