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

Managing Role in Oracle

Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases.     Let’s […]

Read More