Manage common and local users, roles, privileges and profiles in PDBs

Introduction of Multitenant Architecture Common users and Local users: This concept came with Oracle Database 12c. Common Users: a Common user is a user which have the same username and password authentication across PDBs of CDB. Common users are created at CDB level and the common user can connect to the root and perform operations. […]

Read More

Backup CDB and PDBs

Introduction of Multitenant Architecture In this article, we will see how we can take RMAN backup of whole CDB and for the single pluggable database. To take RMAN backup of the whole CDB we can simply take backup by connecting to target as container database and backup database command. Let us see by example : CDB […]

Read More