Using Proxy Access With SQL Developer Web (Doc ID 2780104.1)
This has a “solution” of “Proxy connections are not supported in Web.”
There was a bug logged in 2001: Bug 32936031 ALLOW PROXY CONNECTIONS IN SQLDEV WEB
Proxy connections in SQL Developer Web are very important to us. All the other SQL Developer products allow them, and the lack of this feature is why we are unable to role out SQL Developer Web to all developers at all of our customers.
We can have 15 developers working on a single schema and we don't want everyone logging directly into the database as (for example) HR. Instead, we want them to log in as rich[hr] like they do when they are using SQL Developer for VSCode and/or SQL Developer (the old classic Java program). Yes, of course, the right thing to do is to give each developer their own copy of the database and to use proper CI/CD to promote their changes to a shared development environment that none of the developers log into, but many times customers don't have that type of setup.
Is there a technical reason why only this one version of SQL Developer doesn't support proxy connections? Or is this just a feature that didn't creep up to the top over the last four years?
This really got highlighted when we started to implement Dan's very cool Loki project since “everyone logging in as the same user” really prevents Loki from doing it's thing: apex/utility-apps/loki at 24.1 · oracle/apex
BTW, we LOVE SQL Developer Web. It's really cool. Great job Oracle Team!