Re: DB12c in Production?

In 12c you have a common and local users/roles/privileges. Common is a CDB-wide whereas local is within a specific PDB. The common users/roles/privilege also exist in any PDB but not the other way, that is, a common is also a PDB but a local is not in the root.

Best Regards,

Guenadi Jilevski

On Tue, May 20, 2014 at 9:03 PM, 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