Upcoming Live Webinar Series – Explore the latest innovations in Oracle Enterprise Manager

Exciting news, the long awaited Oracle Enterprise and Cloud Manageability Virtual Classroom Series has been announced and will run this October and November.

The series will include:

  • 7 sessions running weekly from October 13 2020
  • 12+ Oracle experts
  • Live presentations
  • Demos
  • Q&A

During the virtual classes, you will get to explore the latest and greatest innovations Enterprise Manager has to offer.

This is a great opportunity for you to learn and benefit from using Enterprise Manager to manage on-premise and cloud deployments for:

  • Databases
  • Middleware
  • Oracle apps (eg. EBS)
  • Engineered Systems (eg. Exadata, ZDLRA, PCA)

To register please visit:
Oracle Enterprise and Cloud Manageability Virtual Classroom Series

Multitenant Common Users Accessing Application Tables in PDBs

I recently had a requirement where the Common User in a Multitenant DB environment wanted to access application tables across Pluggable Databases (PDBs) but at the same time access dictionary views across all PDBs without the need to manually switch between containers. 

This was because I had to setup a monitoring user account to monitor all PDBs performance as well as application workload.

In this example I will show you how the Common User (created at CDB level) can be configured to access the application tables (create at PDB level)

Continue reading “Multitenant Common Users Accessing Application Tables in PDBs”