RE: DB12c in Production?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 20 May 2014 19:45:38 +0100
Message-ID: <CABe10sarYFuBpU3zwEyeLwUBaYbekE_vne=BrEh_VNOTFaHaNw_at_mail.gmail.com>

I too would love to know the difference. Or how Oracle sell as an extra cost option something that free and cheaper alternatives already have in something other than version 1.0.
On 20 May 2014 19:05, "Iggy Fernandez" <iggy_fernandez_at_hotmail.com> wrote:

> Asking a slightly different question:
>
> I would like to be able to explain the difference between Oracle
> multitenant and the corresponding implementations in SQL Server, DB2,
> MySQL, Postgres, etc. The other guys have had multitenant from the
> beginning but Oracle has had the benefit of hindsight and has presumably
> done things differently/better.
>
> For example, SQL Server differentiates between a "login" (container-level
> authorization) and "user" (database-level authorization). Each login can be
> a user in more than one database within the container. If a database is
> unplugged from one container and plugged into another container, the
> correspondence between "logins" and "users" is messed up. (
> http://www.mssqltips.com/sqlservertip/1590/understanding-and-dealing-with-orphaned-users-in-a-sql-server-database/
> )
>
> An Oracle PDB on the other hand seems to be completely self-contained and
> has no dependence on the CDB. Is that strictly accurate?
>
> Iggy
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 20 2014 - 20:45:38 CEST