Is there a way to specify in a tnsnames.ora file to use a proxy server for connection? I have always directly connected to my Oracle server via TOAD. Due to the Sprint/Cogent outage, I can no longer hit the hosting server directly from my location and am looking for a secure alternative.
The most secure alternative that will work for sure is the 10g oem/sqlplus utilities that will always work through web browser.That's ,of course ,very bad alternative to Toad,I'd try to config Toad use
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.