- 3,715,830 Users
- 2,242,890 Discussions
- 7,845,632 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 472 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
- 254 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 66 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
Proxy connection with no proxy password

Similar to this users issue (https://community.oracle.com/tech/developers/discussion/4294722/using-proxy-users-w-vs-code#latest) I am having problems connecting where the proxy password section is empty. I also tried the connection string provided (User Id=myuser;Data Source=dbhostname:1521/DBSERVICENAME;Proxy User Id=myproxyuser;Proxy Password=myproxypass;)
I also tried using this following connection string
(User Id=myuser; Password=mypassword; Data Source=dbhostname:1521/DBSERVICENAME;Proxy User Id=myproxyuser;Proxy Password=;)
This threw me the error of no empty proxy password. I tried using several combinations but eventually locked our schema which was not an enjoyable experience to get fixed. Using the standard advanced connection the proxy requires input to create the connection thus having to move to the connection string.
As well as the above attempts I have tried using the username[proxy] with no luck. It also seems my google-fu is failing me.
Any help would be appreciated.
Best Answer
-
Looks like I was able to figure it out using the following connection string after digging deeper into one of the threads here.
User Id=proxy;Data Source=dbhostname:1521/DBSERVICENAME;Proxy User Id=userid; Proxy Password=userpassword;
Source of the answer was the following, as provided by Kristian Vinther on dba.stackexchange (I can't post links or I would just provide the hyperlink)
finally found out how to represent the proxy user login via my connection string.
- Proxy User ID = MyUser
- Proxy Password =
MyUser password
- User Id = SchemaName
- User Password not set.
SELECT SYS_CONTEXT('USERENV', 'PROXY_USER'), SYS_CONTEXT('USERENV', 'SESSION_USER') FROM dual
Answers
-
Looks like I was able to figure it out using the following connection string after digging deeper into one of the threads here.
User Id=proxy;Data Source=dbhostname:1521/DBSERVICENAME;Proxy User Id=userid; Proxy Password=userpassword;
Source of the answer was the following, as provided by Kristian Vinther on dba.stackexchange (I can't post links or I would just provide the hyperlink)
finally found out how to represent the proxy user login via my connection string.
- Proxy User ID = MyUser
- Proxy Password =
MyUser password
- User Id = SchemaName
- User Password not set.
SELECT SYS_CONTEXT('USERENV', 'PROXY_USER'), SYS_CONTEXT('USERENV', 'SESSION_USER') FROM dual
-
Hi,
Thanks for posting. It is no longer needed to use the workaround of using an ODP.NET Connection String to connect using a proxy user name and password like you show above..
As of version 19.3.3, we added a Show more options checkbox that will reveal the proxy username and password fields.
So, to connect using a proxy, in the connection dialog, check the Show more options checkbox and provide the proxy username and password in the fields that are revealed.