Database: 11.2.0.3
another company has the operations contract. We have very limited access to production. We use a special PC that we have virtually no privileges on. it just has a internet explorer and notepad installed. we do not have direct access to the database. right now we are stuck using a home grown web application to run queries to support production. our access to production is through the web application that is stored on a middle tier server. the database is behind a firewall. sql developer wont work even though it only requires an unzip since it wont be able to reach the database. sqlplus wont work (and cant be installled on the pc we use to get to production anyway). isqlplus is long since desupported.
this web application we have is pretty bad. I was looking at application express. I have some questions about deploying this. I would just want the 'sql query tool' and thats it.
1. we are not allowed to have production database passwords. web apps use the Oracle OID to log into the DB. can we configure application express where to plug in to our OID. we log in as our selves and then application express logs into the appropriate schema?
2. i am supporting several production databases. do i need an application express schema in each db?
3. in order to handle multiple databases , can i configure the query tool screen to have radio buttons or a drop down list of dbs to connect to different DBs? this would work with the OID. im a DBA, not a web developer, Ill have to ask them how the current web application works.
4. any security issues i should know about?