Switching To CDB$ROOT In PLSQL Block Resulting in ORA-01031: Insufficient Privileges Error (Doc ID 2969011.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

In a multitennant environment switching from PDB to container “cdb$root” using PLSQL block resulting in “ORA-01031: insufficient privileges Error“.
Where as connecting from PDB to CDB%ROOT outside PLSQL block works fine.

Below is the script

Changes

 Since switching from PDB to CDB$ROOT possible outside PLSQL block but not inside PLSQL Block

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.