Tablespaces query error when including pluggable databases (4269549)

Tablespaces query error when including pluggable databases

Since TOAD 13.2 the query to display tablespaces (Database->Administer->Tablespaces) changed, which causes users other then SYS but with DBA privilege and access to all PDB's to fail to display data. Direct usage of SYS user is generally not recommended. The cause is the usage of CONTAINERS clause for the following tables in the query: containers("SYS"."V_$TABLESPACE") containers("SYS"."V_$TEMP_SPACE_HEADER") containers("SYS"."V_$TEMP_EXTENT_POOL") It would require explicit grants for these on each of the PDB to make this work, which is superfluous. This is misuse of the containers clause. All data should be queried from the relevant container data objects (V$, GV$, CDB_ views) which are subject to security access governed by CONTAINER_DATA setting for the common user.

WORKAROUND:

TMB-2201