I am unable to find any documentation related to what privilege can be granted out to a common user in CDB root database which can allow the user to select from V$PDB
server11:CPPPRD:oracle:/u01/app>sqlplus C##IMDBA -- this user has DBA role in the root database
SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 14 08:26:17 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Last Successful login time: Fri Sep 11 2015 15:55:05 -06:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL> select * from v$pdbs;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
server11:CPPPRD:oracle:/u01/app>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 14 08:26:36 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL> select name from v$pdbs;
NAME
------------------------------
PDB$SEED
APPPROD
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options