Locking & unlocking common users in a Multitenant database
Common users in a multitenant database are defined in CDB$ROOT and are then available in all PDBs. Privileges can be granted locally (for a single container) or for the whole container database (CONTAINER=ALL). But what about locking and unlocking these users on the different level.
Monitoring Oracle Database 18c XE with OEM Cloud Control?
Some time ago, a customer asked me, if it possible to monitor Oracle Database 18c Express Edition (XE) with OEM Cloud Control. And – in short – it’s possible and as easy as with the other database editions.
#UKOUGConf20: Taming the PDB
Thanks to all who attended my session on “Taming the PDB – Resource Management and Lockdown Profiles at the UKOUG Conference 2020.