From the course: Oracle Database 12c: Security

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Local vs. common user concepts

Local vs. common user concepts - Oracle Database Tutorial

From the course: Oracle Database 12c: Security

Start my 1-month free trial

Local vs. common user concepts

“

- [Instructor] Oracle 12c introduces a new multi-tenant database architecture where multiple PDBs or Pluggable Databases share the same Oracle instance. With this new architecture change, Oracle also introduces two distinct types of database users. These are common users and local users. The difference between common and local users is pretty straightforward, but nonetheless important. A local user account is the user account that was created inside a PDB. It is local to a unique PDB. For example, if we created a my_user database user in PDB1, then that user will exist in the scope of PDB1 only. We can also create another user with the same name but in another PDB such as in PDB number two. Now, we have two users with the same name, but each is local to its own PDB. Each user will have privileges on objects inside the PDB in which the user was created. On the other hand, common users in Oracle are special users that are created inside the root container using a special naming…

Contents