My Oracle Support Banner

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

Last updated on OCTOBER 06, 2023

Applies to:

PL/SQL - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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