- 3,715,959 Users
- 2,242,917 Discussions
- 7,845,703 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 475 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 5 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 417 SQLcl
- 42 SQL Developer Data Modeler
- 184.9K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 9 DevOps
- 3K QA/Testing
- 256 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 67 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 11 Español
- 1.9K Japanese
- 2 Portuguese
Using Proxy users w/VS Code

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 -
Best 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
Answers
-
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
-
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)
-
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?
-
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.