RE: DB12c in Production?
From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Tue, 20 May 2014 11:03:52 -0700
Message-ID: <BLU179-W8821055037271D4603CF9EEB3D0_at_phx.gbl>
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
Date: Tue, 20 May 2014 11:03:52 -0700
Message-ID: <BLU179-W8821055037271D4603CF9EEB3D0_at_phx.gbl>
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-lReceived on Tue May 20 2014 - 20:03:52 CEST