I often hear from customers: Oracle database server is so expensive. Well, I often answer: That depends! In fact, the Oracle database license costs are similar to software from Oracle’s competitors. Microsoft SQL Server has a different license model though. Oracle has a lot of advantages in its flexible license model as well as number of Open Source initiatives. Together, these options allow an enterprise to get cost savings on their IT investments. Read more »
Oracle recommends that, where possible, you build applications in which application users are database users. In this way, you can leverage the security mechanisms of the database.
Unfortunately from my experience for a lot of commercial packaged software, application users are not database users. For these applications, multiple users authenticate themselves to the application, and the application then connects to the database as a single, highly-privileged schema user containing all the database objects. This is known as so-called One Big Application User model. Why, in spite of Oracle recommendation, the software vendors use in development that database authentication model? Read more »