Sometimes we deploy applications behind the client’s firewall, and we need read-only access to their database to debug problems, because sometimes their IT professionals are not SQL savvy. We want to associate our application with some kind of web application that will open a database and allow us to run adhoc SQL queries and display their output in an HTML table. We do not want to write home code, and we can bundle Java / JSP-based applications.
Our server is Oracle, so we need a solution that can connect to the oracle server and expose it over the Internet.
, , , , , , VPN . VPN, , . , SQL Server, VPN Enterprise Manager . Oracle, , , . VPN , , , .
phpMyAdmin , MySQL. , db , , , , , , , , HTTP Basic .
Oracle - - . .
, , - , - -, , - .
VPN - , VPN, , , VPN , , IP- , , VPN.
In my current project, we use SQL Navigator to run queries in our Oracle database. I also heard decent things about TOAD . I would advise you not to write a web application only to run special SQL queries, because it seems to me that many tools can support your debugging needs.
Source: https://habr.com/ru/post/1697603/More articles:Does VB6 have the equivalent of #pragma pack? - vb6Can Greasemonkey change the display title - firefoxOCSP libraries for python / java / c? - javawhen to pass arguments to a function by reference and by address? - c ++Java EE and Grails: linking to WebServices? What structure? - java-eeError Delphi OTA and RTTI - pluginsIs there a SMART library for .NET or Java? - javaHow do you get a flash mp3 player to keep playing if the user changes the page? - flashArray negative bypass in JScript - javascriptHow would you handle a very large vector in Ruby? - ruby | fooobar.comAll Articles