Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 159 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 473 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Logging on with proxy user

Really looking forward to test this extension. But:
It seems that logging on with a proxy user (user_A[user_B]) does not work. Connecting to user_A or user_B works, but proxy through gives bad username or password. It works in SQL Developer, so the accounts are correctly set up.
Any workarounds?
Regards,
Vidar
Answers
-
Hi,
For now you will need to use a ODP.NET connect string if you want to use proxy authentication. We'll try to improve this soon:
Use option "New Connection"
When prompted for connect string, enter:
User Id=testuser;Data Source=localhost/XEPDB1;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
-
is this still a problem? I have been struggling to get this to work for some time now. I thought I was doing it wrong.
I am on Developer Tools for VS Code (SQL and PLSQL) 21.4.0
As per Vidar above, how to fill in the Create New Connection page - is this below correct?
Connection Type* : TNS Alias
TNS Admin Location* : c:\Users\user_A
TNS Alias : TNSAlias1
Use Wallet : ??? none ???
Wallet File Location : ??? not using ???
Role : Default
Username* : user_A
Password : ??? do I leave this blank here ???
---- Show more Option ✔
Proxy User name : user_B
Proxy Password : ??? do I put user_A' s password ???
Current Schema : *** error : unable to get schema information. Details: ORA-01017:......
Connection name* : auto populated as user_B.TNSAlias1
Clicked Create Connection - Failed with Error opening connection 'user_B.TNSAlias1': Details: ORA-01017
But the login/password is OK. It works fine in SQL Developper and sqlplus .
Thank you .
-
I don't know if it's fixed. I'm using DataGrip for my development work now, so this problem is not a concern for me anymore.
-
actually, from what i have been searching around it should be
Username* : user_B
Proxy User name : user_A
Proxy Password : user_A's password
I have tried that too previously, and again now and it still ain't working.
and I also tried the ODP.NET connection way. I still cannot get this to work either,
I have entered the conn str as mentioned above by Christian with
testuser as user_B
myproxyuser as user_A
myproxypass as user_A's password
for Source=localhost/XEPDB1, what do i put here?
I guess I can't use TNSAlias1 but I have tried something like this which I got from the tnsnames.ora file the following entries HOST= abc-scan.zzzz.abcdefgh.com, PORT=999999 , CONNECT_DATA = (SERVER=dedicated) (SERVICE_NAME= YYYY.xxxx.aaaa.bbbbbbbbbb.com)
Source=//{HOST}:{PORT}/{SERVICE_NAME}
and it is still not working.
Is this correct way?
also , is the ODP connection string secure?
-
HI Thanks Vidar
-
Hi
can anyone from Oracle please comment on this ?
Thanks
-
Hi,
This is a two year old thread. My original answer on this thread is no longer the recommended way to do this as we modified the connection dialog.
Are you able to connect using a proxy user from SQL Developer, SQLCL or SQL*Plus? I just want to make sure it is working on this machine.
You can test this like so:
(connect as sysdba, then) create user testuser identified by passw0rd; grant create session to testuser; create user myproxyuser identified by myproxypassword; grant create session to myproxyuser; alter user testuser grant connect through myproxyuser;
Now when you connect in the dialog you would put "testuser" in the username field. Leave password blank.
Check the "show more options" check box.
Put myproxyuser in the Proxy User Name field and myproxypassword in the Proxy Password Field. Then press connect.
If you get an error, let me know what it is.
-
Thank Christian, I have seen this before or may something like this which probably was wrong and confused me more. so does it mean that I can connect with a TNS Alias now or I still need to use the ODP.net connection string ( if so what is the requirement to use the OPD.net way)
So, I have a user account/password and I want to connect into the database pretending to be another schema user which I do not know the password. Am I testuser or am I myproxyuser? note I do not have sysdba and the accounts are created for me. I am given only my own user (me) and password (myownpassword) and I have been set by the DBA team to be able to connect as 'useriampretending' without that password.
I can connect with sqldev. sqlcl and sqlplus like this:
me[userIampretending]/[email protected]
but note in VScode via TNS Alias or ODP.net connections.
btw what is Advanced Connection string ? May be that would work for me. how to use that with the info I have?
Thank you
-
I would suggest using the TNS Alias connection type. In User Name field put userIampretending.
Check the "show more options" check box
Put me in the Proxy User Name field and myownpassword in the Proxy Password Field. Then press connect.