RE: DB12c in Production?
- From: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 May 2014 11:03:52 -0700
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
Other related posts:
