2 Replies Latest reply on Apr 22, 2020 4:39 PM by Robert Marz

    Oracle Developer Tools for VS Code - Proxy User connections

    Robert Marz

      Hi,

       

      we are heavily using proxy connections at our site - every developer connects with his personal user and the desired schema in square brackets:

       

      alter user hr grant connect through scott;

       

      connect scott[hr]/tiger

       

      And you are connected to the schema hr.

       

      Unfortunately, this doesn't seem to work with Oracle Developer Tools for VS Code 19.3.2.

       

      Am I doing something wrong?

       

      Regards from Germany

       

      Robbie

        • 1. Re: Oracle Developer Tools for VS Code - Proxy User connections
          Christian.Shay -Oracle

          Hi Robbie,

          We plan to make this a lot easier in the next release by giving Proxy Authentication it's own section in the connection dialog. But in this release you will need to use an "ODP.NET connection string".

           

          Here are the steps to follow:

           

          • 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
          • 2. Re: Oracle Developer Tools for VS Code - Proxy User connections
            Robert Marz

            Hi Christian,

             

             

            thanks for yout fast response, this works perfect.

            The only downside is, that you have to store your password. But thats fine for me.

             

            Even easier than an own section for proxy connect would be, if the "square-bracket-syntax" would work, e.g. scott[hr].

             

            SQLDeveloper works that way.

             

            Robbie